Multiple results for vlookup

N

Neall

I have a result list with 5 company names and corolating dates in which they
reported an issue among other information, now I want to break that query
result into a row of dates for each company, the vlookup only seems to return
the first date it finds that relates to the company name how can I have it
continue to scan and return all dates that correspond to the customers name

This is what I am using

=VLOOKUP("ACME*",A3:B373,2,FALSE)

this is what I am looking for as a result (dates only)

ROW A ROW B ROW C
Acme A ACME B ACME J
June 06 Jan 05 Dec 05
april 07 march 05 jan 06
sept 07 march 05 june 06
march 05 july 07
july 07


Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

month gaps counting through whole column 15
vlookup using date ranges 0
Sorting CSV Data By Date 8
Mapping strings to integers 6
dup value deletion 0
Understanding and comparing stock market figures 10
Creating an unique list but applying 2 conditions...can it be done? 6
create worksheet with specific name 2

Top