My problem is similar to Bug 106575.
In sheet A cell C11 must be 1400 instead of 100.
Maybe it has something to do with the search criterion in VLOOUP, because when I change the text in column B the bug is gone.
I try to attach the affected file and the file after changing column B.
If I got it right, in Bug 106575 the problem was solved with Ctrl-Shift-F9.
But that doesn't help in my case.
Wrong value in cell C11
Right value in cell C11
Reproducible: Couldn't Reproduce
User Profile Reset: No
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko
Created attachment 132564 [details]
Created attachment 132565 [details]
file afer changing the text in column B
The issue is you have forgot the last parameter to work with no sorted list.
Wow! 2 Minutes after my report I got the answer! You are really fast m.a.riosv!
Thank you, you are right, the last value for the sort order was missing in my formular.
But I thought, for the reason that this value is optional, that I don't need it in this case.
That the search criterion doesn't have to be exactly the same value, I didn't know. (I have learned that right now in your link to the help: "Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is between the lowest and highest value of the sorted list.")
That was my confusion.
Thanks for your help!