Help With Excel #N/A
 

I have a lookup that is as follows:
=vlookup(vlookup($B6,Analyst,11),Markit,3,False) This lookup goes out to a
sheet to match a ticker symbol and then goes to another sheet to get what I
want. Sometimes, I get #N/A errors which I expect. However, how do I add
the isna function to my lookup so that when I encounter a #N/A it is
converted to say a hyphen like this - Thanks.

Help With Excel #N/A
 

Maybe one way:

=IF(ISERROR(VLOOKUP(VLOOKUP($B6,Analyst,11),Markit ,3)),
"-",VLOOKUP(VLOOKUP($B6,Analyst,11),Markit,3,FAL SE))

HTH,
Paul

"XFILES" wrote in message
...
I have a lookup that is as follows:
=vlookup(vlookup($B6,Analyst,11),Markit,3,False) This lookup goes out to
a
sheet to match a ticker symbol and then goes to another sheet to get what
I
want. Sometimes, I get #N/A errors which I expect. However, how do I add
the isna function to my lookup so that when I encounter a #N/A it is
converted to say a hyphen like this - Thanks.

Help With Excel #N/A
 

That worked. I just had to add an extra False in their and it worked. THANK
YOU SO MUCH!!!

"PCLIVE" wrote:

Maybe one way:

=IF(ISERROR(VLOOKUP(VLOOKUP($B6,Analyst,11),Markit ,3)),
"-",VLOOKUP(VLOOKUP($B6,Analyst,11),Markit,3,FAL SE))

HTH,
Paul

"XFILES" wrote in message
...
I have a lookup that is as follows:
=vlookup(vlookup($B6,Analyst,11),Markit,3,False) This lookup goes out to
a
sheet to match a ticker symbol and then goes to another sheet to get what
I
want. Sometimes, I get #N/A errors which I expect. However, how do I add
the isna function to my lookup so that when I encounter a #N/A it is
converted to say a hyphen like this - Thanks.