» Altering the results returned by VLOOKUP.
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
Problem: Column B contains values to look up in List1 (Column A).
How could we alter the results returned by the VLOOKUP function so that they will include the original value looked up and a ""Found""/""Not Found"" indication?
Solution:
Use the ISNA and VLOOKUP functions in an IF statement, as follows:
=IF(ISNA(VLOOKUP(B2,$A$2:$A$7,1,FALSE)),B2&"" Not Found"",VLOOKUP(B2,$A$2:$A$7,1,FALSE)&"" Found"")
List1_____Values to look______Result
Blue______Pink________________Pink Not Found
Red_______Blue________________Blue Found
Green_____White_______________White Not Found
Black_____Purple______________Purple Not Found
Yellow____Red_________________Red Found
Orange
Book Store:
Recommended Books:
- Microsoft Outlook 2002 for Dummies
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Accounting Principles, with CD, 6th Edition
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
No comments have been submitted.
