New Contributor

Screen Shot 2022-05-14 at 4.51.56 pm.png

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 Replies
best response confirmed by eloisemildenhall (New Contributor)

@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)


This worked!! Thank you so much