ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I retrieve a date in a column of dates which > my criteria (https://www.excelbanter.com/excel-worksheet-functions/44172-how-do-i-retrieve-date-column-dates-%3E-my-criteria.html)

HNOWSKI

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)


All times are GMT +1. The time now is 05:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com