Tip Printed from ExcelTip.com

---

Retrieving the Row Number that Corresponds with a Matched Value in a Look Up


Problem:

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 and simultaneously press .