LOOKUPVALUE function with multiple values into RESULT TABLE

Hi Team,

I need a quick help. I have two tables with one has unique values and another has multiple values.

I need to to repeat my LOOKUPVALUE for all the duplicates reocrds as it is going to repeat same value only. Currently it is giving me one value for each record without making any relationship between them.

Here is table where I weant to pull all the respective Project Names:

TableA:

TableB:

Expected Output [Without making any active relatiosnhip between these two tables]

What I am getting using LOOKUPVALUE is:

Basically, it is not reapeting the output for each duplicate value - ideally, it should wokr very similar to Vlookup in excel.

Please help

Thanks,

Ram