Posted to microsoft.public.excel.worksheet.functions

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
How can I isolate a lookup vectors but not values from autofill?	rjpeltz	Excel Worksheet Functions	2	May 15th 06 07:41 PM
Another way to lookup data	David Vollmer	Excel Worksheet Functions	1	September 23rd 05 05:16 AM
Lookup Vector > Lookup Value	Alec Kolundzic	Excel Worksheet Functions	6	June 10th 05 02:14 PM
Lookup function w/Text and Year	Josh O.	Excel Worksheet Functions	1	February 12th 05 11:27 PM
double lookup, nest, or macro?	Josef.angel	Excel Worksheet Functions	1	October 29th 04 09:50 AM

All times are GMT +1. The time now is 12:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us