Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
HNOWSKI
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Value between 2 dates AG Excel Worksheet Functions 11 August 21st 05 05:32 PM
Compare dates (one cell not in date format) craigcsb Excel Discussion (Misc queries) 5 June 28th 05 05:07 PM
I need a formula to sum column b if column a is between two dates Pam Excel Discussion (Misc queries) 2 April 18th 05 06:18 PM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM
Finding dates within a date range Marcus Excel Worksheet Functions 2 April 5th 05 02:03 AM


All times are GMT +1. The time now is 01:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"