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?