There are two very similar functions in Excel to look for data inside of cells matching parameters that you dictate: SEARCH and FIND. There are so similar, in fact, that one wonders why have two separate functions that perform virtually the identical results and are identical in the construct of the formula. The reader will likely find the SEARCH function more user friendly in the early stages of financial modeling, as it is not case sensitive like the FIND function, and it can incorporate wildcard features that the FIND function cannot use.
Comments are closed.