I'm trying to do a really simple lookup on a data validation field:
I have 4 simple values:
- risk free
- low
- intermediate
- high
and besides those I have the values for those:
- 0
- 0.1
- 0.2
- 0.5
I use the lookup formula as follows:
=LOOKUP(J11,H7:H10,I7:I10)
When I then change the values to let's say low or risk free, it always shows me the value 0.5.
But when I change the words to this:
- abc
- def
- ghi
- jkl
it delivers the right values. I tried several different sheets, browsers as well as google accounts which uses different languages (english & german). Can somebody please explain this to me :D
