Vlookup w/ #N/A suppression

[Stephen]

Is there a way I can wrap a vlookup in an IF statement to suppress #N/A
errors? Something like...

=IF(VLOOKUP(X32,weights.xls!Soil1,3,FALSE)LIKE"#N/A,"",VLOOKUP_(X32,weights.xls!Soil1,3,FALSE))

 

[Niek Otten]

Hi Stephen,

=IF(ISNA(YourFormula),"",YourFormula)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Is there a way I can wrap a vlookup in an IF statement to suppress #N/A
| errors? Something like...
|
| =IF(VLOOKUP(X32,weights.xls!Soil1,3,FALSE)LIKE"#N/A,"",VLOOKUP_(X32,weights.xls!Soil1,3,FALSE))

 

[Stephen]

good show!

thanks!