Excel

[eloisemildenhall]

I need to change the "2" (underlined) that is in the formula into another formula using the IF function so I can copy it over the spreadsheet without just typing "3" or "4" like i have currently. How can I do this? Does this make sense? 

[#2 · Accepted solution]

@eloisemildenhall You could replace the 2 with COLUMN()-3

But this is not very elegant. Perhaps better to replace the 2 with MATCH(E$2,$I$2:$L$2,0)

[#3]

This worked!! Thank you so much