Home |
Search |
Today's Posts |
#1
|
|||
|
|||
LookUp
is there a way to avoid getting the #N/A as a response
when I do a Lookup? i would simply rather return a blank. |
#2
|
|||
|
|||
=IF(ISNA(your formula),"",your formula)
-- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "frank" wrote in message ... is there a way to avoid getting the #N/A as a response when I do a Lookup? i would simply rather return a blank. |
#3
|
|||
|
|||
Can be done in various ways, but the key issue is why you are getting that
error in the first place. Can you share more info? |:) "frank" wrote: is there a way to avoid getting the #N/A as a response when I do a Lookup? i would simply rather return a blank. |
#4
|
|||
|
|||
Check for the error in your formula:
=if(iserror(yourformula),"",yourformula) frank wrote: is there a way to avoid getting the #N/A as a response when I do a Lookup? i would simply rather return a blank. -- Dave Peterson |
#5
|
|||
|
|||
Try something like this...
=IF(ISNA(VLOOKUP(.....)),"",VLOOKUP(.....)) Hope this helps! In article , "frank" wrote: is there a way to avoid getting the #N/A as a response when I do a Lookup? i would simply rather return a blank. |
#6
|
|||
|
|||
Frank
=If(ISNA(VLOOKUP(cell,table,col,false)),"",VLOOKUP (cell,table,col,false)) OR =IF(ISNA(LOOKUP(value,range1,range2)),"",LOOKUP(va lue,range1,range2)) Gord Dibben Excel MVP On Wed, 23 Feb 2005 12:56:31 -0800, "frank" wrote: is there a way to avoid getting the #N/A as a response when I do a Lookup? i would simply rather return a blank. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a lookup table with an added varable? | Excel Worksheet Functions | |||
lookup tables in cells | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
Excel Lookup Functions | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |