Vlookup Frustration
 

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)

"kevincanuk" wrote in message
...
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

Vlookup Frustration
 

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

"Bob Phillips" wrote:

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)

"kevincanuk" wrote in message
...
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