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

=VLOOKUP($A1;Sheet1.$A$2:$A$27;3;0)  https://help.libreoffice.org/6.3/en-U... ## ----------------------------------------------------------------------------- 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 to the left of the answer, to finish the question. more 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.

more

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

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

( 2019-08-26 00:22:42 +0200 )edit

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: https://libreofficehelp.com/how-to-solve-err-502-calc/

more

## Stats

Seen: 4,767 times

Last updated: Aug 26