LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 95
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Vlookup but with multiple results ORLANDO VAZQUEZ Excel Discussion (Misc queries) 22 February 24th 10 07:36 PM
How do I SUM multiple results from a VLOOKUP? garnm2 Excel Worksheet Functions 2 July 18th 08 07:56 PM
Multiple results in Vlookup sarajane18 Excel Discussion (Misc queries) 2 August 10th 07 08:54 PM
Looking up multiple results with VLOOKUP Bob Excel Worksheet Functions 7 July 23rd 07 08:18 PM
Add multiple vlookup results Dawn Excel Worksheet Functions 6 June 20th 06 10:06 PM


All times are GMT +1. The time now is 09:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"