I am using the LOOKUP()
formula to lookup values from column B in column A and for some reason some values are not found even though both columns contain those values.
Is there a known bug in the LOOKUP()
formula that causes this or am I doing something foolishly wrong?
(by the way: I have the same problem with VLOOKUP()
Please see my screenshot for further clarification: