vlookup

[RFJ]

I've got a vlookup table that, correctly, returns #N/A because a value is
missing.

I want to replace the #N/A with a blank cell but can't get the syntax right.

In excel/english what I want to achieve is :

if(vlookup table returns "#N/A" replace with "", else show value returned by
vlookup table)

TIA

 

[Frank Kabel]

Hi
try
=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(..))