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