» 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:
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- The 22 Immutable Laws of Branding
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
No comments have been submitted.


