» 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:
No comments have been submitted.
