Help With Excel #N/A

[Guest]

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.

 

[PCLIVE]

Maybe one way:

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

HTH,
Paul

 

[Guest]

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