Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find the next date for a product
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where can I find a multiple product worksheet for a sales route? | New Users to Excel | |||
Where to find Product Key?(preinstalled) | Setting up and Configuration of Excel | |||
Using VLOOKUP to find product from 3 worksheets to put on one shee | Excel Worksheet Functions | |||
a map to show others where to find product on shelves | Excel Discussion (Misc queries) | |||
How to find the largest product of an array of values? | Excel Worksheet Functions |