Excel Forum

Excel Magic Trick 639: Approximate Match Lookup with Unsorted Column Across Multiple Columns

See how to create a formula that will do an approximate match lookup with an unsorted lookup table that can be copied across multiple columns and do lookup from multiple columns. See the LOOKUP and SMALL functions.
Related video: Mr Excel & excelisfun Trick 36: VLOOKUP w Approximate Match & Unsorted Table

Got a Question? Ask it Here in the Forum.