Both find_text and within_text can be text characters or cell references. You can use VLOOKUP to find data in a sorted or unsorted table. FIND find_text within_text start_num The first 2 arguments are required the last one is optional.
How to use OR function with FIND in Excel.
Finds the smallest value thats greater or equal to lookup_value. The syntax of the Excel Find function is as follows. Lookup_value is 25 but its missing from lookup_array so the position of the next largest number like 34 is returned instead. FIND find_text within_text start_num FINDB find_text within_text start_num The FIND and FINDB function syntax has the following arguments.