I have a spreadsheet table that has columns for the last 10 years. Each new year, these columns are changed to add one year to it. My problem is that I have another workbook table referencing this table with each cell using a formula. I want to be able to change the formula so it references the correct column.
Here is a preview of what the formula looks like.
=LOOKUP(2,1/('ARTICULATED TRUCK AVERAGE HOURS YEARLY.xlsx'!ARTICULATEDTRUCK[2018]<>""),'ARTICULATED TRUCK AVERAGE HOURS YEARLY.xlsx'!ARTICULATEDTRUCK[2018])
Need to change the 2018 to 2019 in the formula.
Here is a preview of what the formula looks like.
=LOOKUP(2,1/('ARTICULATED TRUCK AVERAGE HOURS YEARLY.xlsx'!ARTICULATEDTRUCK[2018]<>""),'ARTICULATED TRUCK AVERAGE HOURS YEARLY.xlsx'!ARTICULATEDTRUCK[2018])
Need to change the 2018 to 2019 in the formula.