Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I retrieve a date in a column of dates which > my criteria
EXCEL 2003
TAB "SHIPPED" Column "A" is a list of serial numbers. Column "B" shows the ship date of the product. Column "C" is called "RETURN DATE". TAB "RETURNS" Columns "A" & "B" show s/n and return date of the products that shipped in "A" & "B" of the "SHIPPED" tab. I want to lookup the return dates of the serial numbers in tab "RETURNS" and find the s/n with the return date than "B" in "SHIPPED". There may be mulitple returns for the same s/n. Some may be < the ship date and some the ship date. I tried VLOOKUP but it only returns the first match. I need to know if the shipped product ever came back as defective. (I.E. Return Date Ship Date for a given s/n) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Value between 2 dates | Excel Worksheet Functions | |||
Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
I need a formula to sum column b if column a is between two dates | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Finding dates within a date range | Excel Worksheet Functions |