In WORKSHEET 1 COLUMN A, I have the word DOG.

In WORKSHEET 2 COLUMN A, I have the word DOG four times.

In WORKSHEET 2 COLUMN B, I have COLLIE, GERMAN SHEPHERD, and POODLE.

What I would like to do is have EXCEL search Column A in WORKSHEET 2 for the word DOG, find all the related cells in COLUMN B WORKSHEET B, and combine them in a singe cell in COLUMN B of WORKSHEET 1.

So in COLUMN B of WORKSHEET 1, I would like to have a cell which has COLLIE, GERMAN SHEPHERD, and POODLE.

I am thinking CONCATENATE is likely to be used but is it more likely an ARRAY. Might someone know how to do this? If so, I would appreciate the help. I know how to take code and embed it into a worksheet and some basic VBA.

Thank You.