Thread: Vlookup w/ #N/A suppression
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stephen[_24_] Stephen[_24_] is offline
external usenet poster
  
Posts: 83
Default 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))



Reply With QuoteReply With Quote