Question

Excel Home Insert Page Layout FormuilasDaa ReviewVew Sort & Find& Formatting-Table Styls 1 Orlando Area Job Fair 2 Annual Attendance by Location ed Onc 1/2015 2018 % of Percent of 2018 Total 201Total Profit from 201 60 7873 8145 9583 10204 10557 453 504879 5105 49524000(952 25202641 25981850 2000 150 938 2325 2542 2900 4501 1,601 7% s 26,79665$ 47,301.28 33% 169,979.15 $203,715.36 12$63300.00 s 76,92548 % $ 31,900.00 S4LSa3.12 14% $ 71,790.95 $88,174.02 6 Central Orlando 83% 4200 4452 77% 2100 2226 81% 4726 5010 8 Kissimmee 40e_自相 In cell H15, enter a VLOOKUP function to determine the 2018 percentage of total attendance for the city listed in cell H14. Use the range A5:H11 as the table array 5 C Reset

Answer 1

Solution: vlookup(H14, A5:H11, 8, False)

Explanation:

Here:

lookup_value is cell no: H14

table_array: A5:H11

col_index_num: 8

range_lookup: It is optional that states that function will return in the event in case does not find an exact match to the lookup_value

Formula applies:

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Putting values:

vlookup(H14, A5:H11, 8, False)