Help! lookup, match and result

[Anbuselvam K]

Hi,

Please find the uploaded excel file, in that sheet i've enter few formulations in first sheet that formulations are the master data.

Input Details:
Product name is Vitamin 1 to Vitamin 12. (A3 to A14)
Raw material name is Ingredient 1 to Ingredient 12. (B2 to K2)

All the products have different percentages of ingredient 1 to 12.

my expected result in second Sheet:

If i enter any of the product name in the first cell, from second cell to 13th cell i need the ingredient quantity from the master data.

Please do the needful..!

 

[Syedali]

Hi,

Please find the uploaded excel file, in that sheet i've enter few formulations in first sheet that formulations are the master data.

Input Details:
Product name is Vitamin 1 to Vitamin 12. (A3 to A14)
Raw material name is Ingredient 1 to Ingredient 12. (B2 to K2)

All the products have different percentages of ingredient 1 to 12.

my expected result in second Sheet:

If i enter any of the product name in the first cell, from second cell to 13th cell i need the ingredient quantity from the master data.

Please do the needful..!

PFA...

 

[Khalid NGO]

Hi,
Check this in B4 sheet2:
=INDEX(Formulation!$A$2:$K$14,MATCH($A4,Formulation!$A$3:$A$14,0)+1,MATCH(B$3,Formulation!$B$2:$K$2,0)+1)

copy accross

 

[John Jairo V]

Hi to all!
Slightly different Formula to Khalid (in choose of initial matrix): In B4 and copy to right:
=INDEX(Formulation!$B$3:$K$14,MATCH($A4,Formulation!$A$3:$A$14,),MATCH(B$3,Formulation!$B$2:$K$2,))
Blessings!

 

[Anbuselvam K]

Thanks for your valuable reply

 

[YasserKhalil]

You can use VLOOKUP

=VLOOKUP($A4,Formulation!$A$3:$K$14,COLUMN(),0)