2.0 Excel Activity 5 - Introduction to the VLOOKUP function

profilejams_r1
2.0ExcelActivity5-IntroductiontotheVLOOKUPfunctionTutorial.xlsx
Home>Mathematics homework help>Statistics homework help>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