Excel Forum



Excel Magic Trick 752: Fill Column With Categories Using Approximate Lookup Formula


Download file: http://people.highline.edu/mgirvin/
See how to Fill Column With Categories Using Approximate Lookup Formula that uses LOOKUP, SEARCH, IF, ISNA and IFERROR functions.





Got a Question? Ask it Here in the Forum.