Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with Excel Lookup tdmcmhaon Excel Worksheet Functions 1 April 7th 05 04:13 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM
how to use lookup a value by date for criteria in Excel sheet dom Excel Worksheet Functions 5 January 11th 05 04:22 AM
Lookup Access data in Excel Chris Kellock Excel Worksheet Functions 1 December 28th 04 01:51 PM
HELP! Excel Lookup formula tommie Excel Worksheet Functions 1 November 29th 04 11:45 AM


All times are GMT +1. The time now is 07:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"