Thread: Excel - open workbook - function - value = 0
View Single Post
 
Old 10-23-2018, 02:34 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2016
Expert
  
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Wouldn't a simple formula like:
=VLOOKUP(C5,ATG!$B$2:$C$1000,2,FALSE)
do it, where C5 is the cell containing the ID?


Or if you wanted the same error message:
=IFERROR(VLOOKUP(C5,ATG!$B$2:$C$35,2,FALSE),"!!!ERROR!!!")
Reply With Quote