Check if 2 cells match on another sheet then lookup value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sarahmarsden - 20 Oct 2006 07:25 GMT

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?

Reply to this Message

vezerid - 20 Oct 2006 12:19 GMT

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$15,0),MATCH(B2,Sheet2!$C$1:$H$1,0))

HTH
Kostis Vezerides

> 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
[quoted text clipped - 6 lines]
>
> Is this possible?

Reply to this Message