Ask Your Question
0

Calc VLOOKUP - enter FALSE as the last parameter

asked 2019-02-13 13:19:46 +0200

Albireo gravatar image

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 flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-02-13 13:51:04 +0200

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-02-13 13:19:46 +0200

Seen: 53 times

Last updated: Feb 13