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
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