Do you really mean:

This is what I have in range A11:A14:

Date Product_Code
06/01/06
06/02/06
06/03/06

And this is what I want in range A11:B14

Date Product_Code
06/01/06 ABC, DEF
06/02/06 GHI
06/03/06 JKL,MNO,PQR

How about making it easy and putting the product codes in separate cells?

Biff

wrote in message
ups.com...
This is what I have in range A1:B7
Product_code Date
ABC 06/01/06
DEF 06/01/06
GHI 06/02/06
JKL 06/03/06
MNO 06/03/06
PQR 06/03/06

This is what I have in range B11:B14
Date Product_Code
06/01/06 ABC, DEF
06/02/06 GHI
06/03/06 JKL,MNO,PQR

I need formulas in range B11:B14 that can search product code from the
given date in range A11:A14