# help me with formulas ppplllleeeaaseee!

#### arbf83

##### New Member
this is what i want to do, if you imagine 2 columns 1 with only 3 different options (words) the other with a sales figure and another spreadsheet with exchage rates again relating to only 3 different options(EUR,GBP,USD) - there are only 2 variables and 3 different simple equations one of which only changes weekly.

i can obviously anchor with \$ but i would like it to use a particular formula for each option when the currency/sales figure/exchange rates are inputed and change the sales figure from the relevant currency into the one i want.

also i use a different exchange rate each week so if it was anchored to the same box then if i were to change the rate it would change all the other figures so maybe a way by which after a week the value is pushed down a row but the box is still linked and the other figures do not change?? you are the experts....please help... can this be done?? i would be very grateful for anyone that can help

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

#### xenou

##### MrExcel MVP
What is the base sales figure currency? You converting "to" GBP, Euros, and USD, but converting "from" ...

Regards.

#### Smitty

##### Legend
Welcome to the Board!

You might get a start with Data-->Validation-->Allow-->List-->Source-->EUR,GBP,USD to allow you to make your three selections then use VLOOKUP to return the relevant exchange rate.

But some more detailed information would be good.

Hope that helps,

Smitty

Replies
0
Views
139
Replies
2
Views
130
Replies
2
Views
256
Replies
9
Views
156
Replies
5
Views
284

1,191,055
Messages
5,984,391
Members
439,883
Latest member
onions44

### 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.

### Which adblocker are you using?

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

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