» Retrieving the Row Number that Corresponds with a Matched Value in a Look Up
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
We want to search List1 (column A) for each of the letters in column C and retrieve the corresponding row number.
Solution:
Use the MAX, IF, and ROW functions as shown in the following Array formula:
{=MAX(IF($A$2:$A$15=C2,ROW($A$2:$A$15)))}
To apply Array formula:
Select the cell, press
Book Store:
Recommended Books:
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- Advanced modelling in finance using Excel and VBA
- Microsoft Outlook 2002 for Dummies
- Microsoft Excel VBA Programming for the Absolute Beginner
- Finance and Accounting for Nonfinancial Managers
No comments have been submitted.
