I have a workbook that has 20+ tabs of profit and loss information for different cost centers. I want to add text in a column A based on what the formula finds in column B. I think I should be using Match/Index but can't quite figure it out.
So....directly below is my reference information.
10555 Total SERVICE INCOME
10666 Total PAYROLL EXPENSE
10777 Total FRINGE EXPENSE
10888 Total Payroll Expenses
10999 NET PROCEEDS/LOSSES
So I want the formula to reference the text in column B and based on that match it up and insert the corresponding number into Column A. Does that make sense at all?
Column A Column B
TOTAL INCOME
Total PAYROLL EXPENSE
Total FRINGE EXPENSE
Total Payroll Expenses
So....directly below is my reference information.
10555 Total SERVICE INCOME
10666 Total PAYROLL EXPENSE
10777 Total FRINGE EXPENSE
10888 Total Payroll Expenses
10999 NET PROCEEDS/LOSSES
So I want the formula to reference the text in column B and based on that match it up and insert the corresponding number into Column A. Does that make sense at all?
Column A Column B
TOTAL INCOME
Total PAYROLL EXPENSE
Total FRINGE EXPENSE
Total Payroll Expenses