get answers from another Tab

[lesley burlingham]

I have 2 tables, one is a calculation with two fields to change. The other tab hold the data.

If I change the Distance in cell D1 and the Period in D2, I want the answer in D6 to change to the answer from he table on the other tab.

Using the data in cell A47:K67 find the distance and period and return the answer. See attached, apologies if I haven't explained myself properly.

 

[Asheesh]

Hi Lesley,

Just try the below in cell D6

SUMPRODUCT(('35S11A8 3xl repair only'!$B$48:$K$67)*('35S11A8 3xl repair only'!$A$48:$A$67=Calculation!$D$1)*('35S11A8 3xl repair only'!$B$47:$K$47=Calculation!$D$2))

 

[lesley burlingham]

Perfect Thank

 

[Asheesh]

You welcome..