Vlookup Against multiple values in a cell?

[Rince91]

Hi,

Reference workbook
I have 2 columns A and B, A contains multiple project numbers and B contains a single value that applies to those project numbers.

A1 will contain 5 project numbers and B1 will contain 1 reference value for those 5 project numbers.

Target workbook
I have a 2nd work book with each project number as a row (split out like any rational human being would do). I need to put the reference in B1 above, into each project line in this 2nd workbook.

I have tried a vlookup with an approximate match but that doesn't work....

Any advice or am i screwed and have to Crtl-F everything....?

Thanks!

EDIT: Attached workbook, so i need to pull the reference from sheet 2 to sheet 1 against the project codes.