Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have the Data on Tab Part E and need to use VLOOKup and sort each item Plant, Size, QTY Used to Tab Part F.

I have the Data on Tab Part E and need to use VLOOKup and sort each item Plant, Size, QTY Used to Tab Part F.

Tab Part E: Data

image text in transcribed

Tab Part F: VLOOKUP Data

image text in transcribed

How do I type in the VLOOKUP criteria?

Thank you in advance!

Oty Used 75 80 82 87 107 40 120 102 35 BLD 115 87 98 125 BUILD/ Quantity in PARK Stock Item# Price Plant BLD 12 1254 P 34.99 Tulips PARK 13 1254-1 55.99 Tulips BLD 48 1578-P 49.99 Roses PARK 5 1578-T 52.44 Geranium PARK 34 1732-T 34.95 Dahlia PARK 42 1765-T 15.99 Spirea PARK 8 1872-T 14.99 Dahlia BLD 31 2234-P 36.95 Hastas BLD 3 2238-P 14.99 Lilac 40 2389-P 15.95 Dieffenbachia BLD 17 2452-P 44.95 Spirea BLD 8 3242-P 29.99 Dieffenbachia BLD 2 3243-P 35.95 Crocus BLD 35 3244-P 45.99 Crocus BLD 62 3245-P 45.95 Dieffenbachia PARK 35 3245-T 49.95 Dahlia BLD 70 3251-P 49.94 Tulips BLD 42 3425-P 35.95 Crocus BLD 42 3450-P 45.95 Marigolds BLD 67 3451-P 34.95 Crocus BLD 3 3452-P 34.99 Dieffenbachia PARK 15 3452-T 13.99 Hastas BLD 45 3453-P 17.95 Crocus BLD 6 3455-P 14.99 Spirea PARK 42 3455-T 14.95 Dahlia BLD 30 3456-P 34.99 Hastas + BLD 45 3458-P 34.95 Daisies BLD 24 3478-P 34.99 Spirea BLD 7 3522-P 35.99 Daisies BLD 4 3543-P 14.95 Spirea PARK 4.3544-T 49.99 Dieffenbachia PARK 4 3562-T 49.95 Lilac BLD 8 3566-P 34.99 Geranium BLD 32 3567-P 34.99 Spirea 88 123 92 Size 10 inch 14 inch 14 inch 10 inch 10 inch 20 inch 14 inch 10 inch 10 inch 20 inch 10 inch 20 inch 14 inch 10 inch 14 inch 14 inch 14 inch 20 inch 14 inch 10 inch 14 inch 20 inch 20 inch 14 inch 20 inch 20 inch 10 inch 10 inch 10 inch 10 inch 10 inch 10 inch 20 inch 14 inch 46 79 82 69 107 103 128 128 130 138 53 49 128 54 93 128 87 88 PARTE PARTE PARTD PARTC PARTB PARTA DATA1 DATA2 DATA3 DAT Item # Plant Size Qty Used 1254-P 1578-P 3455-P 3456-P 3458-P 3478-P 4567-P 4578-P 4678-P 5378-P 5468-P 7843-P 7859-P 7865-P 7892-P 7988-P 3562-T 4232-T

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Strategic Market Management

Authors: David A. Aaker

5th Edition

0471177431, 9780471177432

More Books

Students also viewed these Accounting questions

Question

=+b) What are the upper and lower 3s control limits?

Answered: 1 week ago