ExcelBanter - Vlookup w/ #N/A suppression

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Vlookup w/ #N/A suppression (https://www.excelbanter.com/excel-programming/401597-vlookup-w-n-suppression.html)

Stephen[_24_]

Vlookup w/ #N/A suppression

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

Vlookup w/ #N/A suppression

Hi Stephen,

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Stephen" wrote in message ...
| 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[_24_]

Vlookup w/ #N/A suppression

good show!

thanks!

"Niek Otten" wrote:

Hi Stephen,

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Stephen" wrote in message ...
| 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))

All times are GMT +1. The time now is 03:18 PM.