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



Download File: http://people.highline.edu/mgirvin/excelisfun.htm Learn how to do a two way lookup to retrieve the conversion rate for currencies: 1. (00:11) Two-Way Lookup for Currency Conversion…

source

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

Download File: http://people.highline.edu/mgirvin/excelisfun.htm
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