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: `=VLOOKUP($A1,Sheet1.$A$2:$A$27,3,0)`

Somehow this gives me `Err.502`

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 `A1`

.