LookUp

F

frank

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.
 
R

RagDyer

=IF(ISNA(your formula),"",your formula)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

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.
 
C

CyberTaz

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? |:>)
 
D

Dave Peterson

Check for the error in your formula:

=if(iserror(yourformula),"",yourformula)
 
D

Domenic

Try something like this...

=IF(ISNA(VLOOKUP(.....)),"",VLOOKUP(.....))

Hope this helps!
 
G

Gord Dibben

Frank

=If(ISNA(VLOOKUP(cell,table,col,false)),"",VLOOKUP(cell,table,col,false))

OR

=IF(ISNA(LOOKUP(value,range1,range2)),"",LOOKUP(value,range1,range2))



Gord Dibben Excel MVP
 
Top