Is there a way to have my formulas reference a single cell value so that I can change multiple formulas with the one cell?

user_15079124 0
Viewed 43

For example, I have 3 formulas

=LEFT(Tickets!C14,(FIND(".",Tickets!C14,1)-1))

=Tickets!A14

=Tickets!E14

I am using them to pull information from a table, and create an email for me. If I could alter one cell, and have it change the reference location, I would have what I want/need. (i.e. I need to change "14" to whatever row I am referencing, but I would prefer not to use Find/Replace everytime)

Thanks for any help!

excel-formula excel
1 Answers

Use INDEX:

The basic is that you would replace any reference with INDEX(column,CellRefofTheRow)

So

=Tickets!A14

Becomes:

=INDEX(Tickets!A:A,A1)

Where A1 would hold the row number desired like 14

user_48515900
Related