Ask Your Question

Calc: vlookup gives Err.502 though I'm sure the syntax is correct.

asked 2017-03-14 19:25:12 +0200

medicengonzo gravatar image

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 .

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2019-08-26 01:11:17 +0200

updated 2019-08-26 01:13:34 +0200


=VLOOKUP($A1,Sheet1.$A$2:$A$27,3,0) Error (,) is (;)



ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thank you.

If the answer met your need, please click on the ball Descrição da imagem to the left of the answer, to finish the question.

edit flag offensive delete link more

answered 2017-03-14 20:21:20 +0200

erAck gravatar image

You want to return the third column but the range has only one column. Make that Sheet1.$A$2:$C$27 instead. The lookup is always on the first column of the given range, the index argument indicates the column to return the value from.

edit flag offensive delete link more


That's it. Such a NOOB mistake. Thank you!

medicengonzo gravatar imagemedicengonzo ( 2017-03-15 02:24:27 +0200 )edit

Please, if the answer solves the question click ✔.

m.a.riosv gravatar imagem.a.riosv ( 2019-08-26 00:22:42 +0200 )edit

answered 2019-08-25 20:12:55 +0200

Error 502 occurs when you are passing incorrect/insufficient arguments to a function which it deserves. For your case, VLOOKUP expects entire table range and you should identify the column number properly from the selected table range.

Details of Err:502 is covered with examples:

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-03-14 19:25:12 +0200

Seen: 4,767 times

Last updated: Aug 26