I have a list of values on column
A in column
B I want to apply a VLOOKUP with the search value in
A and the array in another sheet and give me index 3. I use the following formula:
Somehow this gives me
I don’t understand what I am doing wrong.
Also, if I change the formula to look on index 1 it gives me the same value of cell