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

Continue to order Get a quote

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.