Table help Please!?!?!?!
 

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 the
appropriate quantity relative to its recipe item (row a) and recipe code
(b10) of the cell I pasted it in.

Is this possible?:confused:


--
Cook
------------------------------------------------------------------------
Cook's Profile: http://www.thecodecage.com/forumz/member.php?userid=107
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=68997

Table help Please!?!?!?!
 

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
---
"Cook" wrote in message
...

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 the
appropriate quantity relative to its recipe item (row a) and recipe code
(b10) of the cell I pasted it in.

Is this possible?:confused:


--
Cook
------------------------------------------------------------------------
Cook's Profile: http://www.thecodecage.com/forumz/member.php?userid=107
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=68997