Answered step by step
Verified Expert Solution
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
Tab Part F: VLOOKUP Data
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-TStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started