» 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
Problem: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))
List1__Numbers to Check____Result
8______2___________________Number Not Found
5______7___________________7
3______10__________________Number Not Found
7______6___________________6
4
9
6
1
Book Store:
Recommended Books:
- Financial Risk Manager Handbook, Second Edition
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Financial Modeling - 2nd Edition
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
No comments have been submitted.
