![]() |
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