FIND() vs SEARCH() Function in Excel 

Thanks! I couldn't agree more! Honestly, if you don't use both of them for a few weeks, I find it too easy to forget which is which.

You are very welome! I'm glad you think so :)

You're welcome! I'm glad you liked it! I'm thinking I might do more like this one.

Thanks! I'm glad you liked it! I'm thinking of maybe doing more in this style of comparing functions.

I'm not sure, I'd check out this link stackoverflow.com/questions/14667035/vba-for-excel-afterrefresh-event and if that doesn't help, ask on our forum on TeachExcel.com and provide as much info. as you can or a sample file.

Sometimes it happens, specially if you miss the context. Use the search() under this circumstances: when searching for exact match or for pattern or partial lookup of a given character/string/text and as result, you should get the numeric starting position of that string being searched within the cell content. The search () takes three arguments, the string being searched or to be found, the address or map where to be found (cell, sheet, entire workbook), and the starting position to search from).