Excel Forum

Excel Magic Trick 762: Two Way Lookup from Multiple Tables & Lookup Tables Sorted Descending

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to do:
1. Two way lookup where one lookup is sorted ascending and the second is sorted Descending
2. Use MATCH with 3rd argument -1 for table sorted Descending
3. Lookup when there are more than one table using CHOOSE function and the Four Argument INDEX function.

Got a Question? Ask it Here in the Forum.