ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multiple results for vlookup (https://www.excelbanter.com/excel-programming/397919-multiple-results-vlookup.html)

Neall

Multiple results for vlookup
 
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
--
Neall


All times are GMT +1. The time now is 08:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com