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.

How about a userdefined function?

http://groups.google.co.uk/group/mic...961a02186c2878
(one line in your browser)



Jim Burns wrote:
>
> 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

--

Dave Peterson

Excellent advice!! That worked and I'm off and running.

Thank you, Dave for the help!!

How about a userdefined function?

http://groups.google.co.uk/group/mic...961a02186c2878
(one line in your browser)



Jim Burns wrote:
>
> 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

--

Dave Peterson

How about a userdefined function?

http://groups.google.co.uk/group/mic...961a02186c2878
(one line in your browser)



Jim Burns wrote:
>
> 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

--

Dave Peterson

How about a userdefined function?

http://groups.google.co.uk/group/mic...961a02186c2878
(one line in your browser)



Jim Burns wrote:
>
> 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

--

Dave Peterson

How about a userdefined function?

http://groups.google.co.uk/group/mic...961a02186c2878
(one line in your browser)



Jim Burns wrote:
>
> 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

--

Dave Peterson

How about a userdefined function?

http://groups.google.co.uk/group/mic...961a02186c2878
(one line in your browser)



Jim Burns wrote:
>
> 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

--

Dave Peterson

How about a userdefined function?

http://groups.google.co.uk/group/mic...961a02186c2878
(one line in your browser)



Jim Burns wrote:
>
> 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

--

Dave Peterson

How about a userdefined function?

http://groups.google.co.uk/group/mic...961a02186c2878
(one line in your browser)



Jim Burns wrote:
>
> 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

--

Dave Peterson

How about a userdefined function?

http://groups.google.co.uk/group/mic...961a02186c2878
(one line in your browser)



Jim Burns wrote:
>
> 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

--

Dave Peterson

How about a userdefined function?

http://groups.google.co.uk/group/mic...961a02186c2878
(one line in your browser)



Jim Burns wrote:
>
> 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

--

Dave Peterson