Using VLookup to return multiple instances

[TK_Hussar]

Hi
I am looking for a formula that will return the cell numbers of multiple instances of the item found using VLOOKUP. For example if I am looking for
"A123", this may occur in more than one cell in the search range. I want to be able to return all the cell reference numbers of that instance.

Look forward to hearing from anyone that can help.

Many thanks in anticipation.

Kind regards

TK_Hussar

 

[T. Valko]

Thanks for the help. This works great, however, since there is about 6000 rows of data my formula takes a few seconds to recalculate when I chance the lookup value.

Considering what the formulas do and the amount of data involved a "few seconds" is reasonable although it can be annoying if you are constantly doing different lookups.

Have you tried to use AutoFilter? This is exactly what filters are for. No formulas and no delay in calculation.