VLookup

  • Thread starter Thread starter Irina
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLookup formula transposing table_array when copied to another cel 1
Use & with two formulas 2
Using a dynamic pathname in VLOOKUP 7
how to catch the second or more cell with vlookup 8
Vookup related query 3
Format of cells for VLOOKUP 2
How do I insert a dynamic reference of a range inside VLOOKUP? 4
INDIRECT(ADDRESS) inside a VLOOKUP 13

Back
Top