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.