Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup but with multiple results | Excel Discussion (Misc queries) | |||
How do I SUM multiple results from a VLOOKUP? | Excel Worksheet Functions | |||
Multiple results in Vlookup | Excel Discussion (Misc queries) | |||
Looking up multiple results with VLOOKUP | Excel Worksheet Functions | |||
Add multiple vlookup results | Excel Worksheet Functions |