Excel Magic Trick 1235: 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUP 

Download Excel Start File: excelisfun.net...
Download File: people.highline...
Learn how to do a two way lookup to retrieve the conversion rate for currencies:
1. (00:11) Two-Way Lookup for Currency Conversion Problem Set Up
2. (01:17) Don’t use IF and AND functions to create a formula
3. (02:12) Example with INDEX and MATCH functions
4. (07:06) Example with VLOOKUP and MATCH functions
Excel Magic Trick 1235: 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX & MATCH or VLOOKUP & MATCH