I have 2 sheets in one workbook with the same row and column headers. The first sheet reflects the available amount. The second reflects the amount spent. Utilizing =VLOOKUP(A:A,Alloc_011918,44,FALSE) and =SUM(AX5-AW5) becomes tedious insuring the column index is pointing to the appropriate place to generate a remaining balance
I would like to create a 3rd sheet to represent remaining balance. This formula would need to do a column and row lookup on the first 2 sheets, subtract the amounts, and populate the appropriate cell.
Row Labels 1 2 3
CFLN $850,695.97 $229,357.42 $391,208.01
CMFC $380,036.30 $685,517.18 $803,838.49
CMLG $74,548,163.00 $1,359.44 $953.37
CMRD -$7,500.89 $2.00 $32.00
CMTL $1,459,859.44 $1,267,354.39 $556,950.41
Excel 2013 Windows 10
I would like to create a 3rd sheet to represent remaining balance. This formula would need to do a column and row lookup on the first 2 sheets, subtract the amounts, and populate the appropriate cell.
Row Labels 1 2 3
CFLN $850,695.97 $229,357.42 $391,208.01
CMFC $380,036.30 $685,517.18 $803,838.49
CMLG $74,548,163.00 $1,359.44 $953.37
CMRD -$7,500.89 $2.00 $32.00
CMTL $1,459,859.44 $1,267,354.39 $556,950.41
Excel 2013 Windows 10