Ask Your Question

Calc 'Search not found' when data is from VLOOKUP

asked 2020-02-12 22:45:07 +0100

LeeTW gravatar image

I have columns of data in my spreadsheet (insect species names) which is populated via VLOOKUP.

When I use the 'Find' box to take me to a specific line, i.e. Incurvaria masculella - I receive the response ' Search key not found' even though it is clearly there.

I'm assuming this is because the search is seeing the VLOOKUP formula?

Is there a way that I can still use the 'Find' box as there are over 2500 rows so not feasible to manually scroll?

The file is saved as .xlsx

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-02-12 23:06:59 +0100

Lupp gravatar image

Use F&R with Search in : Values.

edit flag offensive delete link more


Excellent, thank you, just need to have that as the default for the 'find-bar'

Much appreciated

LeeTW gravatar imageLeeTW ( 2020-02-12 23:18:06 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-02-12 22:45:07 +0100

Seen: 18 times

Last updated: Feb 12