I am trying to create a lookup table. I have a concatenated field on two
sheets and want all the values that match that field to be populated on one
of the sheets.

Example:

Sheet 1 (flat file)

Concat field Name
GAATSPEC ALLERGY
GAATSPEC ASTHMA
GAATSPEC SINUS
GAATSPEC IMMUNOLOGY

SHEET 2 (results file)

Concat field Name
GAATSPEC

In essence, whenever I select "GAATSPEC" on the second sheet, I want it to
automatically populate with the matching name. My problem is a Vlookup only
gives me the first row (i.e., GAATSPEC - ALLERGY). How do I get all the
other rows to populate with a name?

Is this doable?

--
If you never attempt anything, you will never make any mistakes...thus never
enjoying the fruits of accomplishment.