Check if 2 cells match on another sheet then lookup value
 

I have 2 sheets. Sheet 1 has several columns including Date, Variety,
No of Stems. Sheet 2 is a pivot table based on Sheet 1 data showing
Variety and Max Date.

From the pivot table I need to match Variety and Max Date with Variety
and Date in Sheet 1. Where a row in Sheet 1 contains both matching
values then I want to return No of Stems. (My formula will be on Sheet
2.)

Is this possible?

Check if 2 cells match on another sheet then lookup value
 

Hi,

I assume that in your pivot table Max Date labels are on the horizontal
axis, cells D1:H1. I assume the Variety labels are on the vertical,
cells C2:C15.

In Sheet1 I assume your Variety is in A and Max Date in B.

In C2:
=INDEX(Sheet2!$C$1:$H$15,MATCH(A2,Sheet2!$C$1:$C$1 5,0),MATCH(B2,Sheet2!$C$1:$H$1,0))

HTH
Kostis Vezerides


sarahmarsden wrote:
I have 2 sheets. Sheet 1 has several columns including Date, Variety,
No of Stems. Sheet 2 is a pivot table based on Sheet 1 data showing
Variety and Max Date.

From the pivot table I need to match Variety and Max Date with Variety
and Date in Sheet 1. Where a row in Sheet 1 contains both matching
values then I want to return No of Stems. (My formula will be on Sheet
2.)

Is this possible?