VLookup
 

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.


--
Irina
------------------------------------------------------------------------
Irina's Profile: http://www.excelforum.com/member.php...fo&userid=8685
View this thread: http://www.excelforum.com/showthread...hreadid=396600

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
--
Gary's Student


"Irina" wrote:


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.


--
Irina
------------------------------------------------------------------------
Irina's Profile: http://www.excelforum.com/member.php...fo&userid=8685
View this thread: http://www.excelforum.com/showthread...hreadid=396600