isnumber excel formula generator


Last Displayed Category is often a catch-all, such as Other, or Non Branded. It will categorize anything you aren't searching for into a general bucket.
You can leave blank if you only want to return specific values.

 
Search Terms you enter below are sorted in the order you put them in. If Search Term 1 is "Cat" and Search Term 2 is "Catapult", everything will be sorted under Cat.

Tool inspired by Jeremy Gottlieb’s Moz Article – One Formula to Rule Them All.
Excel ISNUMBER generator instructions.