can vlookup solve this?

<SOLVED> Hello, very new to spreadsheets - only have a basic understanding so far.
However, although this may be a long shot, I am hoping there is a solution.

I have attached a screen capture image which hopefully will explain my dilemma better than trying to describe it here.

Kind regards