Returning all values from a lookup - not just the first/last one

  • Thread starter Thread starter Jim Burns
  • Start date Start date
J

Jim Burns

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.
 
Excellent advice!! That worked and I'm off and running.

Thank you, Dave for the help!!
 
Back
Top