Excel Forum
Similar Content
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Ma...
Filter Data Sets on Multiple Columns with Multiple Criteria at Once in Excel - AutoFilter
Macro: This Excel macro allows you to filter a data set on multiple columns and criteria at once....
Find the Last Column with Data in Excel VBA
Tutorial: How to find the last column in a row that has data. This includes selecting that column or...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.