2.0 Excel Activity 5 - Introduction to the VLOOKUP function
Sheet1
| Product | Order Quantity | Product ID | Unit Price | Gross Sales | Formulas for Columns C, D, & E | Product | Product ID | Unit Price | |||
| Carry-on Suitcase | 2 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | Travel Umbrella | B07NQKQ19S | $13.23 | ||||
| Travel Umbrella | 10 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | Bluetooth Headphones | B01NAJGGA2 | $34.79 | ||||
| Travel Umbrella | 16 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | Battery Pack | B00Z9QVE4Q | $33.38 | ||||
| Bluetooth Headphones | 5 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | Travel Pillow | B00GXBZM5I | $13.59 | ||||
| Carry-on Suitcase | 20 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | Carry-on Suitcase | B07PB3P1N8 | $43.19 | ||||
| Bluetooth Headphones | 25 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Travel Umbrella | 2 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | Pivot Table | ||||||
| Carry-on Suitcase | 27 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Carry-on Suitcase | 21 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Bluetooth Headphones | 28 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Carry-on Suitcase | 23 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Travel Pillow | 9 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Bluetooth Headphones | 2 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Travel Umbrella | 14 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Travel Umbrella | 22 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Battery Pack | 23 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Carry-on Suitcase | 2 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Carry-on Suitcase | 24 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Carry-on Suitcase | 29 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Travel Pillow | 9 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Travel Umbrella | 12 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Battery Pack | 2 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Travel Pillow | 22 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Bluetooth Headphones | 10 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Travel Pillow | 29 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Battery Pack | 6 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Travel Umbrella | 15 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Bluetooth Headphones | 8 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Carry-on Suitcase | 7 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Bluetooth Headphones | 23 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Carry-on Suitcase | 10 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Bluetooth Headphones | 18 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Travel Pillow | 18 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Bluetooth Headphones | 9 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Battery Pack | 25 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Carry-on Suitcase | 3 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Travel Pillow | 26 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Travel Pillow | 21 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Bluetooth Headphones | 22 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Travel Pillow | 14 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Battery Pack | 24 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Carry-on Suitcase | 2 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Battery Pack | 17 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Battery Pack | 19 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Bluetooth Headphones | 24 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Battery Pack | 24 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Carry-on Suitcase | 18 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Bluetooth Headphones | 5 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Carry-on Suitcase | 17 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||||
| Bluetooth Headphones | 14 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A |