» 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:
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- A Mathematician Plays the Stock Market
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Accounting and Financial Fundamentals for Nonfinancial Executives
No comments have been submitted.
