A
Algeraist
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
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