VLLOKUP - more than one result??

L

luvthavodka

My range of data (table array) has more than one row that meet the
VLOOKUP criteria I have set.

I have a VLOOKUP in eg A1 =VLOOKUP($K$1,Order_Log,6,FALSE). In this I
want the first value to be returned (as VLOOKUP does per standard,
using FALSE). This I can do.

In cell A2 however, I would like to return the 2nd value from my range
of data.

In cell A3, the 3rd ....and so on (only up until around the 6th
value).

What do I need to add into my A1 formula, for the 2nd value to be
returned in A2? I guessed it may be as easy as FALSE +1, but this does
not seem to work!

Many thanks

Jenny
 
G

Guest

Hi Jenny,

try to create the same formula on the cell A2, A3, A4, etc changing the 6
before ",FALSE" to &, 8, etc

hope it help
regards from Brazil
Marcelo


"luvthavodka" escreveu:
 

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 - more than one return required 3
Avoiding redundant calculations 7
How can I lookup when match has more than one value? 2
Using Value of a Cell in the Range Reference in VLOOKUP 1
VLOOKUP 1
copy paste value 1
Vlookup and return sheet name also 2
Vlook-up in report with column Expansion 5

Top