Michael O'Flaherty

asked on

# 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

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

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**
You're welcome, Michael! Glad we could help.

ASKER

Each of your comments solved it for me.

Thanks

Michael