=IF(ISNA help

[madhatter40]

I am trying to remove the #N/A in the cell.
Here is the original formula:

Please Login or Register  to view this content.

Here is what I tried and it doesn't work, any suggestions?

Please Login or Register  to view this content.

[daddylonglegs]

Presumably the VLOOKUP will cause the #N/A error - using your approach try

=IF(ISNA(VLOOKUP(C4,LookupLists!E:G,3,FALSE)),"",B4*VLOOKUP(C4,LookupLists!E:G,3,FALSE))

although in Excel 2010 you can employ IFERROR to shorten that, i.e.

=IFERROR(B4*VLOOKUP(C4,LookupLists!E:G,3,FALSE),"")

[madhatter40]

Thanks so much