I have a column on a spreadsheet that combines a lot of "IF" statements such as:
However, I would like to change it so that I am not referencing the column by rather the name of the column in row 1 so it would be something like:
The goal here is that I can shift the columns around or delete columns or add columns and it won't affect the formula as they would find the column where the cell in row 1 is "Calls" opposed to just "J2" or "Time" opposed to "L2".
Excel Formula:
=IF(ISBLANK(J2),"",(IFERROR(IF(J2="Yes",2,0),""))+
IF(ISBLANK(L2),"",(IFERROR(IF(L2>0.05,1,0),""))+
IF(ISBLANK(K2),"",(IFERROR(IF(K2>0.1,1,0),"")))))
However, I would like to change it so that I am not referencing the column by rather the name of the column in row 1 so it would be something like:
Excel Formula:
=IF(ISBLANK("Calls"),"",(IFERROR(IF("Calls"="Yes",2,0),""))+
IF(ISBLANK("Time"),"",(IFERROR(IF("Time">0.05,1,0),""))+
IF(ISBLANK("Year"),"",(IFERROR("Year"(K2>0.1,1,0),"")))))
The goal here is that I can shift the columns around or delete columns or add columns and it won't affect the formula as they would find the column where the cell in row 1 is "Calls" opposed to just "J2" or "Time" opposed to "L2".