vlookup doesn't work

Hi,

In the attachment please see the column highlighted yellow.

It is a simple vlookup but it simply isn't working and produces #N/A

Please can someone help?

many thanks

It's ok, have solved this by making text into values.