Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|
can we hide #N/A display because of VLOOKUP
Hi Zoom!
Same answer as over in programming.
Try:
=IF(ISNA(VLOOKUP(A1;Sheet2!A:C;2;FALSE)),"",VLOOKU P(A1;Sheet2!A:C;2;FA
LSE))
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
|