ExcelBanter - locate a cell value within a range and return its reference

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - locate a cell value within a range and return its reference (https://www.excelbanter.com/excel-discussion-misc-queries/182853-locate-cell-value-within-range-return-its-reference.html)

Adam

locate a cell value within a range and return its reference

Hello

I am trying to locate the value in cell $H$2 and return the reference of its
value in the range $i$2:$n$2.

Does anyone know a formula for this? To locate a cell value within a range
and return its reference

--
Adam
-----------
Windows XP + Office Pro XP

All times are GMT +1. The time now is 02:03 AM.