i have an empty column which i want to be filled in based on the header and sub header of another column.
I want cell R18 to be matched with row 1 AND cell R22 to be matched with row 2.
so the formula in column N can pinpoint exactly which column i want copied over.
this is the formula i currently have but im getting the VALUE! error in the cell
Formula:=INDEX($B3:$M3,1,MATCH($R$18,$B$1:$M$1,0)+$R$22,$B$2:$M$2)
please help.
thanks
Bookmarks