Probably just late in the evening but am trying to capture an adjacent column
to a unique identifier from another worksheet and populate in the original
worksheet. The first worksheet may have duplicate entries but all rows would
need to bring back information e.g.

Worksheet 1 :
Column A
12345
12345
15432
14325
Worksheet 2 :
Column A Column B
12345 Bananas
12432 Apples
15325 Pears

Worksheet 1 after add function :
12345 Bananas
12345 Bananas
12432 Apples
15325 Pears

Anything simple would be good although in the future likely to be pulling
back several cells of information adjacent and unique to the identifier.

Thanks