In the file attached you can see how the function vlookup (in Italian 'CERCA.VERT') doesn't work if the desired value is inserted manually in the cell.


It works instead if inserting with a copy&paste from another specific cell.
The translation of text in the file is:
"As you can see, even if the text '84100' is correctly digited in B2, D1 doesn't return 10,9 as it should.
Instead, copying and pasting the value of A1 in B2 the function works properly"

I checked the exact value and it's correct; also cell formatting should be ok.
I suppose it's something that has to do with the data type but I absolutely don't know what.

Thanks for help!

Attached Files

Test CERCA.VERT.xlsx (10.3 KB, 12 views)