Excel Magic Trick 1235


2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUP
Learn how to do a two way lookup to retrieve the conversion rate for currencies:
(00:11) Two-Way Lookup for Currency Conversion Problem Set Up
(01:17) Don’t use IF and AND functions to create a formula
(02:12) Example with INDEX and MATCH functions
(07:06) Example with VLOOKUP and MATCH functions