I need Index match please to solve this problem
Insert Calibri 11 ' ' > > General 5 DX Delete v OM Paste B I U .... Av $ - % Conditional Format as Cell Formatting Table Styles Sort & Find & Filter Select Format Analyze Data E Clipboard F Font Alignment Number Styles Cells Editing Analysis E20 X fi G J O Q R S BOC Code H Currency USD EURO CDN M N BOC - Daily Rate Table https://www.bankofcanada.ca/rates/exchange/daily-exchange-rates/ Instructions: Create a formula in Column D to convert the Amount (Column B) into Canadian Dollars using the exact date. Total You can find the daily currency exchange rates in the URL above. Download the CSV and import as a seperate worksheet. The best solution will recognize and incorporate that currency exchange rates are constantly changing. 1 Date 2 12-Jan-19 3 13-Jan-19 4 14-Jan-19 5 15-Jan-19 6 16-Jan-19 7 17-Jan-19 8 18-Jan-19 9 19-Jan-19 10 20-Jan-19 11 21-Jan-19 12 22-Jan-19 13 23-Jan-19 14 24-Jan-19 15 25-Jan-19 16 26-Jan-19 17 27-Jan-19 18 28-Jan-19 19 29-Jan-19 20 30-Jan-19 21 31-Jan-19 22 01-Feb-19 23 02-Feb-19 24 03-Feb-19 25 04-Feb-19 26 05-Feb-19 27 06-Feb-19 LO7 B D F Amount Currency Amount in $CDN Match Date Match Currency 1,246 USD 1,045 EURO 1,940 CDN 1,840 EURO 1,024 USD 2,432 USD 2,449 USD 1,392 USD 1,819 EURO 1,720 EURO 1,645 EURO 1,833 EURO 2,232 EURO 1,192 EURO 1,021 EURO 1,486 EURO 1,030 EURO 1,040 EURO 1,270 EURO 1,081 CDN 1,380 CDN 1,236 CDN 1,732 CDN 1,308 CDN 2,030 CDN 1,050 CDN 107 CON CurrencyExchange-1 CurrencyExchange-2 CurrencyExchange-3 Ready Insert Calibri 11 ' ' > > General 5 DX Delete v OM Paste B I U .... Av $ - % Conditional Format as Cell Formatting Table Styles Sort & Find & Filter Select Format Analyze Data E Clipboard F Font Alignment Number Styles Cells Editing Analysis E20 X fi G J O Q R S BOC Code H Currency USD EURO CDN M N BOC - Daily Rate Table https://www.bankofcanada.ca/rates/exchange/daily-exchange-rates/ Instructions: Create a formula in Column D to convert the Amount (Column B) into Canadian Dollars using the exact date. Total You can find the daily currency exchange rates in the URL above. Download the CSV and import as a seperate worksheet. The best solution will recognize and incorporate that currency exchange rates are constantly changing. 1 Date 2 12-Jan-19 3 13-Jan-19 4 14-Jan-19 5 15-Jan-19 6 16-Jan-19 7 17-Jan-19 8 18-Jan-19 9 19-Jan-19 10 20-Jan-19 11 21-Jan-19 12 22-Jan-19 13 23-Jan-19 14 24-Jan-19 15 25-Jan-19 16 26-Jan-19 17 27-Jan-19 18 28-Jan-19 19 29-Jan-19 20 30-Jan-19 21 31-Jan-19 22 01-Feb-19 23 02-Feb-19 24 03-Feb-19 25 04-Feb-19 26 05-Feb-19 27 06-Feb-19 LO7 B D F Amount Currency Amount in $CDN Match Date Match Currency 1,246 USD 1,045 EURO 1,940 CDN 1,840 EURO 1,024 USD 2,432 USD 2,449 USD 1,392 USD 1,819 EURO 1,720 EURO 1,645 EURO 1,833 EURO 2,232 EURO 1,192 EURO 1,021 EURO 1,486 EURO 1,030 EURO 1,040 EURO 1,270 EURO 1,081 CDN 1,380 CDN 1,236 CDN 1,732 CDN 1,308 CDN 2,030 CDN 1,050 CDN 107 CON CurrencyExchange-1 CurrencyExchange-2 CurrencyExchange-3 Ready
