I did search the forum but haven't found a thread that appears to address this--if I missed it, my apologies.

I'm using Excel 2010 and have 2 worksheets and want to lookup values from Worksheet1 and concatenate data in Worksheet2 Column D into a cell in Worksheet 1. I've been wracking my brain trying to figure this out and thought folks here must have encountered a similar situation.

Constraints:
I am unable to use Morefunc.
I am not proficient in VBA.

Does anyone have any thoughts?