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?
|