Thread: Check if 2 cells match on another sheet then lookup value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sarahmarsden sarahmarsden is offline
external usenet poster
  
Posts: 2
Default 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?

Reply With QuoteReply With Quote