» Checking If Matching Numbers Exist in Different Ranges
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem: Column A in Range1 contains numbers. Columns A & B in Range2 contain numbers and their matching text.
For each number in Range1, we want to find a match in Range2 and then copy that number's corresponding text to column B for Range1.
Solution:
Use the IF, ISNA, and VLOOKUP functions as shown in the following formula:
=IF(ISNA(VLOOKUP(A3,$A$9:$B$14,1,FALSE)),"Not Found",VLOOKUP(A3,$A$9:$B$14,2,FALSE))
Book Store:
Recommended Books:
- Accounting for Dummies
- How to Use Financial Statements: A Guide to Understanding the Numbers
- The Analysis and Use of Financial Statements
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
No comments have been submitted.
