Hello jrtaylor,
Sorry for the delay. I was busy feeding my animals and eating dinner.
This formula can be added in cell "L4" and drug down. This will automatically update the values for the column to the left of the formula. This will keep working when a new column is added. However, if there are no values in the cells Excel will display an "#N/A" error in the cell.
This formula is volatile meaning it will be updated whenever any other cell is calculated. If your worksheet becomes quite large then the volatile functions may impact calculation speed negatively. Here is the formula...
=VLOOKUP(INDIRECT("RC[-1]",FALSE),A13:C32,3,FALSE)*INDIRECT("RC[-1]",FALSE)*INDIRECT("RC2",FALSE)
Bookmarks