# Calc VLOOKUP - enter FALSE as the last parameter

Background .: I have a column (“K”) about 1500 rows, and another column (“A”) with about 30000 rows.

My wish .: I want to find the value in cell K2, in column A and show the contents from column B.

An example .: the cell K2 have the value 1234-1. The cell A45 have the same value 1234-1. Now I want the value from cell B45 in cell L2.

I have tried to use `=LOOKUP(\$K2; A\$2:A\$30000; \$B\$2:\$B\$30000)` in cell L2. It works, but if the value in column K doesn’t exist, I got the wrong value in cell L2. Then I found in the manual Spreadsheet Functions / VLOOKUP

To prevent this, enter FALSE as the last parameter in the formula so that an error message is generated when a nonexistent number is entered.

How to do that? `=VLOOKUP(\$K2; \$A\$2:\$I\$30000; 2 FALSE)` or `=VLOOKUP(\$K2; \$A\$2:\$I\$30000; 2; FALSE)` doesn’t work for me.
The same possibility seems to be lacking in the LOOKUP instruction. Is it true?

Use 0 or FALSE() as the last parameter:

``````=VLOOKUP(\$K2; \$A\$2:\$I\$30000; 2; FALSE())
=VLOOKUP(\$K2; \$A\$2:\$I\$30000; 2; 0)
``````

The same possibility seems to be lacking in the LOOKUP instruction. Is it true?

Yes.