Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 11-24-2021, 12:00 AM
ArviLaanemets ArviLaanemets is offline Help with Excel Formula Windows 8 Help with Excel Formula Office 2016
Expert
 
Join Date: May 2017
Posts: 961
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Formula - Help guiverdi Excel 2 07-23-2017 11:48 PM
Help with Excel Formula excel if formula LPerry Excel 2 03-06-2017 07:14 AM
excel formula jcaal50 Excel 6 05-16-2014 04:01 PM
excel help Formula sellspeed Excel 15 03-10-2010 10:57 AM
Help with Excel Formula Excel Formula Help Shahzad Excel 1 12-07-2008 04:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft