» Using a VLOOKUP Formula to Check If a Value Exists
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem: 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:
- Microsoft Excel Version 2002 Step by Step
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- Microsoft Office XP Introductory Concepts and Techniques
No comments have been submitted.
