Here we have used the MID formula in excel MIDB171SEARCH B171. In this MID Formula example the MID function searches the string at B17 and start the substring from the first character here search function fetches the location of space and return the integer value. Compare Cells in the Same Row using IF formula If you want to get a more descriptive result you can use a simple IF formula to return Match when the names are the same and Mismatch when the names are different.
Because Mary is in row 4 VLOOKUP returns the value from row 4 in column C 22.
Next in the Go to Special window select the Formulas radio button. IF AND in Excel Formula. It also has tons of code examples of Find you can use right now. Instead of manually counting how often a certain value or number appears let Excel do the work for you.