Thread: N/A Value in Lookup Formula
View Single Post
 
Old 03-29-2019, 07:33 AM
ArviLaanemets ArviLaanemets is online now Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
As you use Office2003, IFERROR() is not an option. So you'll have to use
Code:
= IF(ISERROR(VLOOKUP(...)),"",VLOOKUP(...))
Reply With Quote