Excel question again around dates

Closed
Algeraist Posts 1 Registration date Tuesday 18 November 2008 Status Member Last seen 18 November 2008 - 18 Nov 2008 à 23:06
netgear3 Posts 11 Registration date Thursday 16 October 2008 Status Member Last seen 12 May 2009 - 19 Nov 2008 à 05:17
Hello,
I have an excel document with two sheets, sheet1 contains a list of product codes in column A and a date next to each in column B. Sheet2 is almost the same but with different dates and some products aren't on the list.

For each product code - In column C on sheet one I want to find the same product code from sheet2 and pick up the date next to it if it is greater than the date in column B. If there is no match I was going to leave the cell blank.

I've tried index/match with if statements and lookups but with no success

Any ideas.... Thanks in advance
Related:

1 response

netgear3 Posts 11 Registration date Thursday 16 October 2008 Status Member Last seen 12 May 2009 1
19 Nov 2008 à 05:17
hello,

just try to see on the following link :

http://office.microsoft.com/en-us/excel/default.aspx