Forum Discussion

asd6231's avatar
asd6231
Copper Contributor
Apr 01, 2019

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...
excel
Formulas and Functions
asd6231's avatar
asd6231
Copper Contributor
Apr 02, 2019

Twifoo 

 

Hey, thank you, this worked in the end!  I swear I'd tried using CELL "address" before, but it did finally work.

  • kellygneiting's avatar
    kellygneiting
    Copper Contributor
    Oct 11, 2019

    asd6231 Can you please give me the actual formula?  Thank you!

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Apr 02, 2019
    I’m delighted to learn that.

Resources