VLOOKUP or XLOOKUP for Currency Conversion in Excel Formula? Excel Magic Trick 1758

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1758.xlsx
Learn how to create a formula to convert a source currency amount into a target currency amount using a two-way lookup conversion lookup table. Learn five different formulas:
(00:00) Currency Conversion Introduction
1. (00:26) Do NOT us IF function!
2. (00:58) INDEX and MATCH formula
3. (01:17) VLOOKUP and MATCH formula
4. (02:38) XLOOKUP formula
5. (04:17) VLOOKUP and XMATCH formula.
(05:09) Conclusion and Video links

ExcelIsFunTue, October 5, 2021 7:53pm