Hi All,
I have 2 sheets, first sheet has Unique value by which i will compare the second sheet.

However, in the second sheet i have Unique value 3 times in a cells and corresponding column cells has 3 values against this Unique value.

I want to use Vlookup to find this Unique value and then use concatenate the corresponding values as my result.

Example:
Sheet A
Cell A2=N100
Cell A3=N200

Sheet B
Cell A2=N100 B2=OPEN
Cell A3=N100 B3=RELEASE
Cell A4=N100 B4=CLOSE
Cell A5=N200 B3=OPEN


RESULT SHOULD BE
Sheet A
Cell B2= OPEN RELEASE CLOSE


Thanks in advance for your help.