» Using a VLOOKUP Formula to Check If a Value Exists
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Column B contains values to look up in List1 (Column A).
We want to modify the results returned by the VLOOKUP function to include the lookup term as well as an indication of whether or not the value was found.
Solution:
Use the IF, ISNA, and VLOOKUP functions as shown in the following formula:
=IF(ISNA(VLOOKUP(B2,$A$2:$A$7,1,FALSE)),B2&"Not Found",VLOOKUP(B2,$A$2:$A$7,1,FALSE)&"Found")
Book Store:
Recommended Books:
- Financial Risk Manager Handbook, Second Edition
- Mortgages For Dummies®
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Understanding Financial Statements
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
Using a VLOOKUP Formula to Check If a Value Exists
skip
Great tips - I was on the microsoft site for over an hour trying to figure it out, took me 5 minutes with this tip. Thanks!
Using a VLOOKUP Formula to Check If a Value Exists
gvasuus
Worked well. Thanks a lot.
