Excel Forum
Similar Content
Getting Data from a UserForm
Tutorial: How to get data from a UserForm in Excel, including from: text inputs (TextBox), list boxe...
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...
Guide to Combine and Consolidate Data in Excel
Tutorial: Guide to combining and consolidating data in Excel. This includes consolidating data from ...



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.