LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Jim Burns
 
Posts: n/a
Default Returning all values from a lookup - not just the first/last one


I would like to return all values from a data set to a single cell. The
list would look concatenated with a semi-colon - as in
value1;value2;value3. Not sure how to do this...

Everything I'm reading is returning single values (as a vlookup does).
But my data set has more than 1 value that meets the criteria and I'd
like to return them all (preferrably in a single cell).

Any help would be welcomed.

Thank you.


--
Jim Burns
------------------------------------------------------------------------
Jim Burns's Profile: http://www.excelforum.com/member.php...o&userid=24389
View this thread: http://www.excelforum.com/showthread...hreadid=379834

 
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
Lookup Table Dilemma Karen Excel Worksheet Functions 2 June 10th 05 08:22 PM
Using SumIF formulas with multiple lookup values Chris Freeman Excel Worksheet Functions 3 April 13th 05 01:40 AM
Lookup Function - Specific Values Steve Elliott Excel Worksheet Functions 6 April 9th 05 07:15 PM
Need help with lookup and comparing values Steve Excel Worksheet Functions 7 January 30th 05 02:38 PM
How do I lookup and return different values when the lookup value. kg Excel Discussion (Misc queries) 1 January 20th 05 12:53 AM


All times are GMT +1. The time now is 12:36 PM.

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"