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.