Question: For the data set below, use a VLOOKUP formula to determine the location of the Echo contract. Enter the formula in cell H84. Business Unit
| For the data set below, use a VLOOKUP formula to determine the location of the Echo contract. Enter the formula in cell H84. | ||||
| Business Unit | Client | Location | Profit | |
| Operations & Maintenance | Alpha | DC | $ 30,996.00 | |
| Facilities | Bravo | MD | 6,088.80 | |
| Facilities | Charlie | VA | 1,195.40 | |
| Administrative | Delta | MD | 10,487.00 | |
| Service | Echo | DC | 14,229.30 | |
| Operations & Maintenance | Foxtrot | DC | 3,078.40 | |
| Service | Golf | DC | 9,224.00 | |
| Energy Management | Hotel | MD | 37,534.20 | |
| Service | India | MD | 1,319.90 | |
| Energy Management | Juliett | VA | 20,504.80 | |
| Facilities | Kilo | VA | 10,046.50 | |
| Total | $ 144,704.30 | |||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
