Step 29 of 40: Operating Expenses Step 25 B C D E F 20 Operating Expenses Per Month 12 Operating Expenses 21 Payroll 16,000 13 Payroll -16000 22 7,000 14 utilities VLOOKUP($A13,Inputs/$A$21:$8$23,2,FALSE) 23 Other 19,500 12 Enter the VLOOKUP Expense accounts are listed 17 formula shown below. on the Inputs worksheet. If 18 Net your VLOOKUP returns #NIA 19 If you select cells A1:B23 on the Inputs tab intead of typing out check for trailing spaces after 20 the address Excel may replace the cell addresses with the table the expense names. 21 name, in this case Table1. Thus either the formula below or OUTLI 22 =VLOOKUP($A10, Table1,2FALSE) are acceptable. Inputs Search A B =-VLOOKUP($A13,Inputs!$A$21:$B$23,2,FALSE) 12 Operating Expenses lookup value table_array col_index_num [range_lookup] SA13 Inputs ISA$21:$8$23 2 FALSE what to look for cell coordinates of our column from type of match Total rating Expenses (in this case, list, or Excel may put which to return 0 or FALSE: exact the word something like Table1 data match YOUR TURN: Add formulas to Payroll) if you select the cells 1 or TRUE: carry the expense account instead of typing the approximate match names over to cells A13:A15. address Operating Budget Cash Bu - Order of Operations Operating Budget Cash Budget Students Excel We're here to help. Email us at support@studentsexcel.com 34 / 46 03:00 / 06:07