Hi All,

I'm kind of stuck trying to fix a loopup between two worksheets.

Column P of sheet 1, contains multiple references to a Sheet called TOM,

So column P would look something like TOM001.001, TOM002.007

What I need to achieve is for each value in Column P (which corresponds to Column A of worksheet TOM), copy the value in TOM Column B, to Sheet1 column Q comma separated.

A vlookup got it to do it when column P only had one value, but I can't figure out how to do it iteratively.
=VLOOKUP(P2,'TOM'!$A1:$B97,2,FALSE)

If I can get this to work, I might need to add another mapping between TOM column C and Sheet 1 column R

Anyone able to help?

Many thanks
Asparak