![]() |
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