Forum Discussion
Combining ADDRESS with an INDEX MATCH formula, to find cell reference
Hi there, I currently have an INDEX MATCH formula which is working across 2 spreadsheets and returning the value of the cell I want it to, but I want it to return the reference of the cell instea...
Hey, thank you, this worked in the end! I swear I'd tried using CELL "address" before, but it did finally work.
asd6231 Can you please give me the actual formula? Thank you!