My VLOOKUP does not work because cells with a formula that give a result identical to a cell with typed text are not the same

I have a complex formula that gives me the result I want on one sheet.
On another I have typed text identical to the result of the formula, but when I paste the value of the formula into a cell its contents are preceded by an apostrophe causing the VLOOKUP to fail.

I have attached the file with notes describing the problem on sheet Notes in that file

Thanks
Michael
EE why does formula result in different answer to a typed in cell with the same text as the formula result.xlsx