Vlookup Frustration

K

kevincanuk

Hoping someone can help me with a VLOOKUP problem. I have two simple VLOOKUPS
in my workbook. One works great, the other does not. They are virtually the
same. They both have the same set of numbers but one is reversed from the
other. Example one table looks at 123 and returns 1
124 " "
2 and so on
The other is just the opposite
looks at 1 " "
123 and so on
The problem is the second table works fine but for some reason the first one
always returns the last number in the table no matter what number number is
entered. Thanks for any help.
Kevin
 
B

Bob Phillips

Have you added a ,FALSE parameter at the end of the function.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
P

Pete_UK

Are you looking for an exact match (with a fourth parameter in the
VLOOKUP formula of FALSE or 0)? Are your numbers really numbers, and
not text values that just look like numbers? Please post your formulae
and part of your tables then we will be able to help further.

You could, of course, just have a bit of arithmetic to subtract 122 in
the first case and to add 122 in the second case, but maybe there is
another reason for you to do it using VLOOKUP.

Hope this helps.

Pete
 
K

kevincanuk

Thanks all, here is the formula that I am using.
=IF(A16>0,(VLOOKUP(A16,trucks,2)),"")
I have tried it with out the IF statement ...same problem.
 
D

Dave F

Try this: =IF(A16>0,VLOOKUP(A16,trucks,2),"")

Note the parentheses are slightly different than what you have,
specifically, you don't need a parentheses before VLOOKUP.

Dave
 
K

kevincanuk

Thank you all for your help, And thanks Bob, adding the FALSE parameter cured
the problem.
 
Top