LookUp

  • Thread starter Thread starter frank
  • Start date Start date
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.
 
=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.
 
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? |:>)
 
Check for the error in your formula:

=if(iserror(yourformula),"",yourformula)
 
Try something like this...

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

Hope this helps!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null 2
Converting to Number for V Lookup 6
Return value greater than in LOOKUP 3
Return 0 instead of #n/a 1
Returning Formatting on a Lookup 2
Lookup table returns #N/A 2
lookup 4

Back
Top