» Preventing a VLOOKUP Function from Returning an Error when an Exact Match is Not Found
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
We want to create a formula to check whether each number in column B appears in List 1 (Column A).
For each successful search, the formula should return that number.
However, if an exact match is not found, the formula should return a text message to that effect, rather than an error.
Solution:
Use the IF, ISERROR, and VLOOKUP functions as shown in the following formula:
=IF(ISERROR(VLOOKUP(B2,$A$2:$A$9,1,FALSE)),"Number Not Found",VLOOKUP(B2,$A$2:$A$9,1,FALSE))
Book Store:
Recommended Books:
- Microsoft Office XP Introductory Concepts and Techniques
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- The Analysis and Use of Financial Statements
- Writing Excel Macros with VBA, 2nd Edition
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
No comments have been submitted.
