Nested IF and VLOOKUP functions

[Cheryl]

I'm using the VLOOKUP function to return an exact value or #N/A, if no
value is found. I am trying to use the IF function to then convert
the error value of #N/A to a zero (0) where #N/A exists or just insert
the appropriate number using VLOOKUP. I'm hoping that someone can
help me identify where I'm going wrong. I am not experienced using
Excel functions but have read up on the nesting, IF and VLOOKUP
functions via HELP. I'm using Excel 2000. Here's what I have so far:
=IF(VLOOKUP(Sheet1!A21,'Docs'!$A$4:$B$93,2,FALSE)="#N/A","0",VLOOKUP(Sheet1!A21,'Docs'!$A$4:$B$93,2,FALSE))

Thank you in advance for your help.

Cheryl

 

[Ken Wright]

=IF(ISNA(Your_Formula),0,Your_Formula)

Your_Formula being VLOOKUP(Sheet1!A21,'Docs'!$A$4:$B$93,2,FALSE)

 

[Peo Sjoblom]

Try something like this instead





=IF(ISNUMBER(MATCH(Sheet1!A21,Docs!$A$4:$A$93,0)),VLOOKUP(Sheet1!A21,Docs!$A
$4:$B$93,2,FALSE),0)

 

[Cheryl]

Thank you very much Ken. Your solution worked like a charm.

Cheryl