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 Mat...
Guide to Combine and Consolidate Data in Excel
Tutorial: Guide to combining and consolidating data in Excel. This includes consolidating data from ...
Using Formulas with Tables in Excel
Tutorial: Easy way to reference data tables and make formulas within a data table. This allows you ...



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.