View Single Post
  #1   Report Post  
Anne Troy
 
Posts: n/a
Default Excel finds a value that is not in the lookup range

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

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