Excel question again around dates
Closed
Algeraist
Posts
1
Registration date
Tuesday November 18, 2008
Status
Member
Last seen
November 18, 2008
-
Nov 18, 2008 at 11:06 PM
netgear3 Posts 11 Registration date Thursday October 16, 2008 Status Member Last seen May 12, 2009 - Nov 19, 2008 at 05:17 AM
netgear3 Posts 11 Registration date Thursday October 16, 2008 Status Member Last seen May 12, 2009 - Nov 19, 2008 at 05:17 AM
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
Related:
- Excel question again around dates
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
1 response
netgear3
Posts
11
Registration date
Thursday October 16, 2008
Status
Member
Last seen
May 12, 2009
1
Nov 19, 2008 at 05:17 AM
Nov 19, 2008 at 05:17 AM
hello,
just try to see on the following link :
http://office.microsoft.com/en-us/excel/default.aspx
just try to see on the following link :
http://office.microsoft.com/en-us/excel/default.aspx