# 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? edit retag close merge delete ## 1 Answer Sort by » oldest newest most voted 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.

more