The FIND() function returns the position of the found character. As you can see, FIND() returns a value, not a character. This value represents the position of the found character, in this case ...

This function will take a table, find a value in the left-most column ... then tell it if you want an exact match. Then, boom, the function finds "Eric" in the 9th row of column A, then returns ...

Excel’s VLOOKUP() function finds a specific value in the leftmost volume of ... forces VLOOKUP() to find an exact match. For more on this argument, read Troubleshoot VLOOKUP() formula gotchas.