I am using the formula shown below to refer to the name of a column in the table named "Tbl_Prices". Cell E9 contains the name of the column which is "Volume 1".
The formula shown below exists in cell I13. My problem is that when I copy the formula to the cell below I13 which would be I14, the formula changes the reference from E9 to E10. I want E9 to be absolute and stay at E9. I tried putting dollar signs around the E and 9 $E$9 but an error occurs. What is the proper syntax to make E9 absolute and not change when I copy the formula? I need to copy this formula down 2000 rows!
{=INDEX(INDIRECT("Tbl_Prices["&E9&"]"),MATCH($C15&$D15,Tbl_Prices[Category]&Tbl_Prices[Finish size],0))}
Bookmarks