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.

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

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.

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

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.

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.