|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
|
|
Mar 30th, 2004, 03:17 PM
|
#1 |
|
Join Date: Mar 2004
Posts: 21
|
LOOKUP
I understand that if the LOOKUP function can not find a exact match, it chooses the largest value in the lookup_range that is less than or equal to the value.
Is there anyway round this? |
|
|
|
Mar 30th, 2004, 03:22 PM
|
#2 |
|
MrExcel MVP
Join Date: Sep 2002
Location: Alabama/State of Disarray
Posts: 10,473
|
Re: LOOKUP
Hi, Hello, and Welcome to MrExcel -- see the VLOOKUP function. With its 4th argument set to FALSE/0, it forces an exact match as in --
=VLOOKUP(TargetString, SearchArray, Column, 0 )
__________________
just_jon Book of the Month: I'm Not Really an MVP, I Just Play One on TV [j. jon, 2004] 
|
|
|
|
|
Mar 30th, 2004, 03:22 PM
|
#3 |
|
Join Date: Aug 2003
Location: England
Posts: 4,584
|
Re: LOOKUP
Hello,
Yes, add ,0 at the end i.e. =VLOOKUP(A1,B1:D4,3,0) this will return #N/A if an exact match isn't found.
__________________
------------------------- Hope this is helpful. ------------------------- only a drafter, but broadening my Excel knowledge. |
|
|
|
|
Mar 30th, 2004, 10:25 PM
|
#4 |
|
Join Date: Mar 2004
Posts: 21
|
Re: LOOKUP
Many thanks for your help! Didn't expect such a quick response. Very impressed new user
|
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Hybrid Mode
