You can use VLOOKUP to find data in a sorted or unsorted table. As straight forward as it may look like there are several facts which one should bear in mind while using the FIND Function. The FIND function is a built-in function in Excel that is categorized as a StringText Function.
As a worksheet function the FIND function can be entered as part of a formula in a cell of a worksheet.
VBA Find Step 1. The location is returned as the number of characters from the start of within_text. The text you want to find. The FIND function in Excel is used to return the position of a specific character or substring within a text string.