SOLVED

New Contributor

Excel

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

Re: Excel

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

Re: Excel

This worked!! Thank you so much