Equivalent to clicking the Find and Exit Find commands on the Data menu in Microsoft Excel version 4.0. Selects records in the database range which match criteria in the criteria range.
Syntax
DATA.FIND(logical)
Logical is a logical value that specifies whether to enter or exit the Data Find mode. If logical is TRUE, Microsoft Excel carries out the Find command; if FALSE, Microsoft Excel carries out the Exit Find command. If logical is omitted, the function toggles between Find and Exit Find.
Related Functions
DATA.FIND.NEXT Finds next matching record in a database
DATA.FIND.PREV Finds previous matching record in a database
Return to index