Excel finds a value that is not in the lookup range

S

stumped

In my excel 2003 workbook, I use a lookup formula to look up a value in a
different worksheet. The value is found in the range, but I cannot see the
value (the range is only 1 column, and 60 rows. What is going on? What am I
missing?
 
A

Anne Troy

Probably you need a final argument in your vlookup, like so:

=vlookup(cell,range,column,false)

The false tells it NOT to find the closest value if there's not an exact
match. Otherwise, it's finding the closest value.
************
Anne Troy
www.OfficeArticles.com
 
Top