mixlMultilookup 3.02.2
his mixlMultilookup add-in will help you to find more than one result associated with the lookup item, where a vlookup function will return only a single result from the first match it finds. For example, suppose you have a list of items that has more than one storage location, and you need to find all their locations, This lookup macro will return all the multiple locations associated with the lookup item, and may serve as a very useful tool if you were running a stock-take.
This lookup add-in is simple and easy to use. Just remember to select an empty column to return your lookup values so you don't overwrite any important data. If unsure of the macro action and how it works, then please save you work before running the macro. This is a useful and versatile tool which can also perform simple vlookups. The add-in logic can also be modified and applied to return multiple values across large spreadsheets with a single click.