Ask Your Question

searching among VLookup results [closed]

asked 2016-04-27 21:36:57 +0100

BK498 gravatar image

updated 2020-09-04 12:29:01 +0100

Alex Kemp gravatar image

I have a sheet in a database in LibreOffice that has an entire column of names that are VLOOKUP results from another sheet. I'd like to be able to use the find function (or another function if there's something else I should use) to search for specific names among the VLOOKUP results. When I try to do this with Find it says, "search key not found" even when I know the name I'm searching for is there.

Is there a way to do what I am trying to do?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-04 12:29:36.192623

2 Answers

Sort by » oldest newest most voted

answered 2016-04-28 00:57:53 +0100

Lupp gravatar image

updated 2016-04-28 01:00:32 +0100

FIND is searching in a string and returning the number of the first character of a match inside that string if it found one. You cannot use it for your purpose thereforr.
You have to use MATCH to search for matching cells inside a 1D-range. Read the help, please, and probably the Calc Guide. Regard the related option settings for Clac.

edit flag offensive delete link more

answered 2016-04-28 23:51:01 +0100

erAck gravatar image

Make sure that if the values of the column to be looked up are not strictly sorted you pass 0 as the last argument (for the "sort order" parameter) of VLOOKUP(), same with MATCH().

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-04-27 21:36:57 +0100

Seen: 51 times

Last updated: Apr 28 '16