90.2K

Verified Solution

Link Copied!

Due tonight please help...

The formula should use cell H2 (the Tour Code) as the lookup_value, the range A1:E22 as the table_array, 2 as the col_index_num, and FALSE as the range_lookup value.

here is the spreadsheet,

The cell is correct

Tour Code	Tour	Depart Date	Price	Seats Reserved		Tour Information
758H	Pacific Odyssey	1/12/2018	$ 2,255	20		Tour Code	966W
120A	Amazing Amazon	1/13/2018	$ 2,466	18		Tour
431V	Amazing Amazon	2/22/2018	$ 2,134	15		Depart Date
762N	Hiking Patagonia	2/28/2018	$ 2,812	15
215C	Pearls of the Orient	3/13/2018	$ 2,350	15		Price
251D	Silk Road Travels	3/19/2018	$ 2,110	19		< 2000
966W	Photographing France	3/20/2018	$ 1,755	20		Number of Tours
830L	Old Japan	3/23/2018	$ 2,450	22
245M	African National Parks	4/8/2018	$ 3,115	10
334Q	Experience Cambodia	4/11/2018	$ 2,441	21		Tour
325B	Biking in France	4/15/2018	$ 1,900	19		Amazing Amazon
754Q	Amazing Amazon	4/23/2018	$ 1,925	20		Average Price
543Y	Catalonia Adventure	5/9/2018	$ 2,587	17
556J	Treasures of Ethiopia	5/18/2018	$ 1,638	5
675Y	Monasteries of Bulgaria	5/20/2018	$ 1,663	11
544T	Biking in France	5/23/2018	$ 1,635	10
778W	Magnificent Montenegro	5/27/2018	$ 1,890	4
446R	Catalonia Adventure	6/9/2018	$ 2,100	15
677Y	Nepal Trekking	6/9/2018	$ 4,200	18
433Q	Corfu Sailing Voyage	6/10/2018	$ 2,190	10
335V	Amazing Amazon	8/23/2018	$ 2,877	18

Answer & Explanation Solved by verified expert

See Answer