Vlookup multiple same value

Hi all,

if possible i am after some guidance or direction with regards to the attached sheet. Basically i am looking for a product (which has the same value but different results)

could anyone help me achieve in understanding what i would require to achieve the example shown in the attached

yours humbly empty_space