Thread: lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default lookup

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