ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel finds a value that is not in the lookup range (https://www.excelbanter.com/excel-worksheet-functions/42163-re-excel-finds-value-not-lookup-range.html)

Anne Troy

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?





All times are GMT +1. The time now is 09:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com