Find last exact match in column

[sharky12345]

Can someone show me how to find the row number last exact match in column C?

The values are all numeric, so it needs to be a precise match and must be the last value found as there will be duplicates.

Sheet1

	C
1	1234
2	12345
3	1234
4	1234456
5	XXX
6	1234
7	XXX
8	XXX
9	1234
10	XXX
11	3447589
12	3816444.5

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4


In the example above, if I searched for '1234' I'd expect the result to be row 9.

 

[kweaver]

I think this array formula (CTRL+Shift+Enter) should do it (adjust the 12 rows accordingly):

=MAX((1234=C1:C12)*ROW(1:12))

 

[Eric W]

This non-array formula will also work:

=LOOKUP(2,1/(C1:C12=1234),ROW(C1:C12))