Find Cell Reference of a Value Within a Table

Occasional Contributor

I'm looking to input a value in a cell and have a formula find the cell reference of that value within a table. Here is a screenshot to show what I mean. 


Screenshot 2022-08-04 133331.png

6 Replies



Try this (Range being your data range or named item).




If you don't have the very latest version of Excel:



Would there be a way to do this if the values were strings instead of numbers?


Yes, it should work the same way.


Perhaps this (Ctrl_Shift_Enter):




Below formula should work both for numbers and texts. Try-