Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using LookUP
Hi,
If LOOKUP can't find the value I am looking for, it is giving the result from the next smallest value. But, if the LoopUp can not find matching, I just want either False or N/A. How do I get this? Please Help, Radha |
#2
|
|||
|
|||
Radha, add a 4th argument FALSE to your formula, i.e.
=vlookup(a1,myrange,3,false) ************ Anne Troy www.OfficeArticles.com "Radha" wrote in message ... Hi, If LOOKUP can't find the value I am looking for, it is giving the result from the next smallest value. But, if the LoopUp can not find matching, I just want either False or N/A. How do I get this? Please Help, Radha |
#3
|
|||
|
|||
Sorry...should've explained. The FALSE tells Excel NOT to find the nearest
value, but to find the EXACT value. See: http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "Radha" wrote in message ... Hi, If LOOKUP can't find the value I am looking for, it is giving the result from the next smallest value. But, if the LoopUp can not find matching, I just want either False or N/A. How do I get this? Please Help, Radha |
#4
|
|||
|
|||
Use Vlookup() with 0 or False ( for exact match) as the fourth argument.
-- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Radha" wrote in message ... Hi, If LOOKUP can't find the value I am looking for, it is giving the result from the next smallest value. But, if the LoopUp can not find matching, I just want either False or N/A. How do I get this? Please Help, Radha |
#5
|
|||
|
|||
You will have the option to require an exact match if you use the VLOOKUP
function instead of LOOKUP. On Tue, 27 Sep 2005 14:19:05 -0700, "Radha" wrote: Hi, If LOOKUP can't find the value I am looking for, it is giving the result from the next smallest value. But, if the LoopUp can not find matching, I just want either False or N/A. How do I get this? Please Help, Radha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another way to lookup data | Excel Worksheet Functions | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |