Thread: [Solved] Help with Excel Formula
View Single Post
 
Old 11-24-2021, 12:00 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
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
Code:
=IFERROR(IF(VLOOKUP($A2,'W11 Supported (Intel Core)'!$A$2:$A$256,1,0)>"","Yes","No"),"No")
IF part will really never return FALSE, returning an error instead - so you have to use IFERROR to cover this.
Reply With Quote