Ask Your Question
0

searching among VLookup results

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

BK498 gravatar image

updated 2016-04-27 21:38:25 +0100

I have a sheet in a database in LibreOffice 5.0.5.2 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 close merge delete

2 Answers

Sort by » oldest newest most voted
0

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
0

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 40 times

Last updated: Apr 28 '16