Below is a spreadsheet of purchase orders for a computer hardware retailer. Perchase Orders Item Supplier Description Cost Quantity Order Onphics 4 Rex Technologies Card 5.89 35 53115 20 5 Rex Technologies Monitor Rex Technologies Keyboard $15 Rex Technologies Speakers Max's Wavetech D Cables $150 15 $2250 25 40 5600 $15 20 $300 55 10 $50 9 Max's Wavetech Processor $278 27 $6950 30 10 Max's Wavetech Hard disk 5120 18 $2160 SE RADABA Cost per A/P Terms Order (Months) No Order Size AL123 Large AL234 Small 15 AL345 Large 25 AL456 25 KO876 20 K0765 Large KO654 11 Item 12 Supplier Order Size Cast 13 Rex Technologies Large 14 Max's Wavetech 15 The function returns a value or reference of the cell at the intersection of a particular row and column in a given range. 1) VLOOKUP(lookup_value, table_array, col_index_num) 2) INDEX(array, row_num, col_num) 3) MATCH(lookup_value, lookup_array, match_type) 4) HLOOKUP(lookup_value, table_array, row_index_num)