Different currency count on multiple sheets

tonio11

New Member
Joined
Dec 10, 2019
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
Hi

I have a bank transaction workbook for accounts in

sheet 1 =USD,
InfoNameDateInfo2TransactionDebitDepositCurrency
Bank feeBanka Koper d.d.01.01.11.Obresti pozitivnega stanja11010111182363890.001.41USD
Bank feeBanka Koper d.d.03.01.11.Tromesečno izplačilo realnih obresti11010311187900320.000.18USD
WagesMladen Anzulovic03.01.11.Wages DPG 11-1011010311195516074,060.000.00USD
Bank feeBanka Koper d.d.03.01.11.Ostale plačilne transakcije na drugo banko - i-Net110103111955160712.830.00USD

sheet 2 =EUR,
InfoNameDateInfo2TransactionDebitDepositCurrencyEUR 2 USD
UplataMONTEGREEN S.R.L.03.01.11.INV 04011110 MONTEGREEN11010311193046030.002,099.00EUR
UplataMONTEVERDE DI NAVIGAZIONE S.P03.01.11.INV 1010+1110 MONTEVERDE11010311193046040.003,805.00EUR
UplataMacon d.o.o03.01.11.Invoice 11-1011010311195516563,013.000.00EUR

sheet 5 = EUR/USD history currency rate
DateEURUSD
01.01.11.11.3362
02.01.11.11.3362
03.01.11.11.3348

Main currency is USD.

In EUR sheet in last column EUR 2 USD I would like to convert euro to usd using dates from eur sheet 2 and sheet 5 with and count conversion rate on specific date.
Should I use lookup formula or....
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Hi

Yes use the following Vlookup formula to convert EUR to USD:

=VLOOKUP(C3,Sheet5!A:C,3,FALSE)*G3

sheet 2 =EUR,
InfoNameDateInfo2TransactionDebitDepositCurrencyEUR 2 USD
UplataMONTEGREEN S.R.L.03.01.11.INV 04011110 MONTEGREEN
1.1E+15​
0​
2,099.00​
EUR
2801.745​
UplataMONTEVERDE DI NAVIGAZIONE S.P03.01.11.INV 1010+1110 MONTEVERDE
1.1E+15​
0​
3,805.00​
EUR
5078.914​
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,180
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top