Running Total in one currency - but debits in mulitple currency.

**NBVC** · 06-29-2011, 12:58 PM

Do you (or can you) have a separate column that shows the currency of each transaction?

Then you can have a lookup table of exchange rates and use VLOOKUP to capture the correct conversion and use that to get the £.

**Scotty501** · 06-29-2011, 05:26 PM

Originally Posted by NBVC

Do you (or can you) have a separate column that shows the currency of each transaction?

Then you can have a lookup table of exchange rates and use VLOOKUP to capture the correct conversion and use that to get the £.

Sure - I have a blank page. So I can put in whatever is required. The only constant at this stage is the starting point of £60,000.

Could you explain a little more on the lookup idea? I use vlookup so I would be comfortable using this - just not sure on the starting point.

**NBVC** · 06-30-2011, 07:48 AM

Well,

My idea is that you enter the values as numbers only, like 60000 starting
in adjacent column you enter the currency, like £...

You would have a table off to the side of currencies and exchange rates

So assuming your first entry is in A2 and in B2 you have a currency of £

and assuming your table is in X2:Y5

Then make an entry in A3 and place corresponding currency in B3

In a new column say C2 enter =A2 (you can format this as £) in C3 you would have a formula like:

=C2-A3*VLOOKUP(B3,$X$2:$Y$5,2,0)