Hi experts.
I want to see in result tab ingredients and its cost samples shown below based on the selection of Grade Name in A1, from the data list shown below at last, please help with formula but not VBA code. Thanks in advance.
Result tab
Sample 1
Sample 2
Data
I want to see in result tab ingredients and its cost samples shown below based on the selection of Grade Name in A1, from the data list shown below at last, please help with formula but not VBA code. Thanks in advance.
Result tab
Sample 1
SetJet 50 CD Bulk | ||||||||||
Track | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
Component ID | 200018010 | 200018011 | 200018012 | 100018015 | 100018016 | 100018028 | 100018032 | 400018001 | 400018002 | 400018009 |
Component Name | ZESSA-B010 | ZESSA-B011 | ZESSA-B012 | ZESSA-A015 | ZESSA-A016 | ZESSA-A028 | ZESSA-A032 | Blending | Logistic | S & H |
Cost PKR/Litre | 144.22 | 25.39 | 13.70 | 24.91 | 14.09 | 14.87 | 1.76 | 9.25 | 8.30 | 3.11 |
Sample 2
SetJet 50 CD 1 ltr | |||||||||||||||
Track | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
Component ID | 200018010 | 200018011 | 200018012 | 100018015 | 100018016 | 100018028 | 100018032 | 400018001 | 300018007 | 300018015 | 300018023 | 300018031 | 400018003 | 400018002 | 400018009 |
Component Name | ZESSA-B010 | ZESSA-B011 | ZESSA-B012 | ZESSA-A015 | ZESSA-A016 | ZESSA-A028 | ZESSA-A032 | Blending | ZESSA-BT Plastic Bottle SetJet 50 CD 1 ltr | ZESSA-LA Label F SetJet 50 CD 1 ltr | ZESSA-LA Label B SetJet 50 CD 1 ltr | ZESSA-CT Carton 12 x 1 SetJet 50 CD 1 ltr | Filling 1 ltr | Logistic | S & H |
Cost PKR/Litre | 144.22 | 25.39 | 13.70 | 24.91 | 14.09 | 14.87 | 1.76 | 9.25 | 25.95 | 4.15 | 4.15 | 25.95 | 4.15 | 8.30 | 3.11 |
Data
Track | Grade Name | Component Id | Component Name | Dosage %age | Cost PKR/Litre | MONTH | year 2 |
1 | SetJet 50 CD Bulk | 200018010 | ZESSA-B010 | 75.00% | 144.22 | Jan | A2021 |
1 | SetJet 50 CD Bulk | 200018011 | ZESSA-B011 | 13.00% | 25.39 | Jan | A2021 |
1 | SetJet 50 CD Bulk | 200018012 | ZESSA-B012 | 6.00% | 13.70 | Jan | A2021 |
1 | SetJet 50 CD Bulk | 100018015 | ZESSA-A015 | 3.00% | 24.91 | Jan | A2021 |
1 | SetJet 50 CD Bulk | 100018016 | ZESSA-A016 | 1.50% | 14.09 | Jan | A2021 |
1 | SetJet 50 CD Bulk | 100018028 | ZESSA-A028 | 1.00% | 14.87 | Jan | A2021 |
1 | SetJet 50 CD Bulk | 100018032 | ZESSA-A032 | 0.50% | 1.76 | Jan | A2021 |
1 | SetJet 50 CD Bulk | 400018001 | Blending | 0.00% | 9.25 | Jan | A2021 |
1 | SetJet 50 CD Bulk | 400018002 | Logistic | 0.00% | 8.30 | Jan | A2021 |
1 | SetJet 50 CD Bulk | 400018009 | S & H | 0.00% | 3.11 | Jan | A2021 |
2 | SetJet 50 CD 1 ltr | 200018010 | ZESSA-B010 | 75.00% | 144.22 | Jan | A2021 |
2 | SetJet 50 CD 1 ltr | 200018011 | ZESSA-B011 | 13.00% | 25.39 | Jan | A2021 |
2 | SetJet 50 CD 1 ltr | 200018012 | ZESSA-B012 | 6.00% | 13.70 | Jan | A2021 |
2 | SetJet 50 CD 1 ltr | 100018015 | ZESSA-A015 | 3.00% | 24.91 | Jan | A2021 |
2 | SetJet 50 CD 1 ltr | 100018016 | ZESSA-A016 | 1.50% | 14.09 | Jan | A2021 |
2 | SetJet 50 CD 1 ltr | 100018028 | ZESSA-A028 | 1.00% | 14.87 | Jan | A2021 |
2 | SetJet 50 CD 1 ltr | 100018032 | ZESSA-A032 | 0.50% | 1.76 | Jan | A2021 |
2 | SetJet 50 CD 1 ltr | 400018001 | Blending | 0.00% | 9.25 | Jan | A2021 |
2 | SetJet 50 CD 1 ltr | 300018007 | ZESSA-BT Plastic Bottle SetJet 50 CD 1 ltr | 0.00% | 25.95 | Jan | A2021 |
2 | SetJet 50 CD 1 ltr | 300018015 | ZESSA-LA Label F SetJet 50 CD 1 ltr | 0.00% | 4.15 | Jan | A2021 |
2 | SetJet 50 CD 1 ltr | 300018023 | ZESSA-LA Label B SetJet 50 CD 1 ltr | 0.00% | 4.15 | Jan | A2021 |
2 | SetJet 50 CD 1 ltr | 300018031 | ZESSA-CT Carton 12 x 1 SetJet 50 CD 1 ltr | 0.00% | 25.95 | Jan | A2021 |
2 | SetJet 50 CD 1 ltr | 400018003 | Filling 1 ltr | 0.00% | 4.15 | Jan | A2021 |
2 | SetJet 50 CD 1 ltr | 400018002 | Logistic | 0.00% | 8.30 | Jan | A2021 |
2 | SetJet 50 CD 1 ltr | 400018009 | S & H | 0.00% | 3.11 | Jan | A2021 |
3 | SetPlus 10W40 CF4 Bulk | 200018010 | ZESSA-B010 | 67.00% | 129.35 | Jan | A2021 |
3 | SetPlus 10W40 CF4 Bulk | 200018011 | ZESSA-B011 | 15.00% | 29.41 | Jan | A2021 |
3 | SetPlus 10W40 CF4 Bulk | 200018012 | ZESSA-B012 | 7.00% | 16.05 | Jan | A2021 |
3 | SetPlus 10W40 CF4 Bulk | 100018009 | ZESSA-A009 | 6.50% | 33.20 | Jan | A2021 |
3 | SetPlus 10W40 CF4 Bulk | 100018017 | ZESSA-A017 | 1.50% | 7.37 | Jan | A2021 |
3 | SetPlus 10W40 CF4 Bulk | 100018035 | ZESSA-A035 | 1.00% | 1.42 | Jan | A2021 |
3 | SetPlus 10W40 CF4 Bulk | 100018041 | ZESSA-A041 | 1.00% | 1.88 | Jan | A2021 |
3 | SetPlus 10W40 CF4 Bulk | 100018045 | ZESSA-A045 | 1.00% | 2.16 | Jan | A2021 |
3 | SetPlus 10W40 CF4 Bulk | 400018001 | Blending | 0.00% | 9.25 | Jan | A2021 |
3 | SetPlus 10W40 CF4 Bulk | 400018002 | Logistic | 0.00% | 8.30 | Jan | A2021 |
3 | SetPlus 10W40 CF4 Bulk | 400018009 | S & H | 0.00% | 3.11 | Jan | A2021 |