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?
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.
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().