VLookup

I

Irina

Hi guys,

I use VLookup function to get data from array. In the source I could
get more than one row. Can I get next row with the same lookup_value?
Or at least can I get address of cell that was found by VLookup?

I will appreciate any clue,

Thanks a lot in advance,

Irina.
 
G

Gary's Student

Once VLOOKUP tells you the value, use the MATCH function to find its
position. Once you have its position (row), just index down as far as you
want

Good Luck
 
Top