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...
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...
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....



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.