tcaseriaCopper ContributorAug 04, 2022Find Cell Reference of a Value Within a Table 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. Show More
tcaseriaCopper ContributorAug 04, 2022Would there be a way to do this if the values were strings instead of numbers?
Harun24HRBronze Contributor to tcaseriaAug 05, 2022tcaseria Below formula should work both for numbers and texts. Try-=ADDRESS(MAX(ROW(A1:H15)*(A1:H15=K2)),MAX(COLUMN(A1:H15)*(A1:H15=K2)),4)
