hornyleprechaun

A1 = VLOOKUP for Value of "1"
B1 = VLOOKUP for Value of "2"
C1 = VLOOKUP for Value of "3"

Col E --- Col F
1113 --- 1
1113 --- 2
1113 --- 3


If I do VLOOKUP(1113,E1:F3,2,FALSE) it returns a Value of "1"

How do I write the VLOOKUPs so I can lookup either of the 3 values for 1113?

rza49311

iTrader: (1)

This might help.

http://www.get-digital-help.com/2009...okup-in-excel/

Whiskers

4?

The Dougler

iTrader: (1)

Possibly using the match function.

oo7spy

The syntax of the function is (value, range, return column, exact match)

So you are asking for it to look for 1113, in the cells E1:F3, return the second column, and look for an exact match of 1113. Since it found 1113 in E1 and was an exact match, it returned the value of F1 which corresponds to the second column.

Why are all the E values 1113? That is what is stopping you.

You will likely have to use a different function if you cannot change "1113" for each cell.

svtmike

If you're trying to VLOOKUP the values in columns A,B,C based on the value in Column D and a column number in column E, you have to get the columns in a different order; the lookup column has to be the first in the range. Either re-arrange the columns, or set formulas in G=A, H=B, I=C, and then the third argument of your VLOOKUP should be F+2.

oo7spy

This is what I see while reading your suggestion.

svtmike

That's kind of what I see when trying to discern what he's trying to do.

oo7spy

Yes, he has three y values for one x value. The vertical line test fails, he doesn't have a true function, and inherently, the computer is doing the best it can.

He's doomed.

65 Fury Convert

I use the vlookup function all the time. From what I know it won't do what you're trying it to get it to do. A vlookup matches data in a cell range and copies it to data on another spreadsheet.

65 Fury Convert

Are you just trying to search for the cells that contain 1113? If so you could do a control "f", type in 1113 and it will find the 1113's for you