Table help Please!?!?!?!

[Cook]

Template Tab

B10= 1 of 5 recipe codes (PA7, AL6, etc.)
Row A= Recipe items
Row B= Quantity of recipe item

Table Tab

B1,C1,D1,E1,F1= Recipe Codes
A2-A64= Recipe itmes
B2-64= Recipe quantiites

The problem...
I would like a generic equation that would look up on the table tab th
appropriate quantity relative to its recipe item (row a) and recipe cod
(b10) of the cell I pasted it in.

Is this possible?:confused

 

[Max]

In sheet: Table,
Put this in B2:
=IF(B$1=Template!$B$10,INDEX(Template!$2:$2,MATCH($A2,Template!$1:$1,0)),"")
Copy down

Success? Click the stars.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik