Hi I have 2 columns with drop down boxes. Column A has many options that I can select in a drop down list. Examples are I buy foreign currency, I sell foreign currency, I buy C$, I sell C$, I buy GBP, I sell GBP. Column B has a list of currencies (C$, US$, GBP for example). Column C is where I input a number (say 100,000), and Column D is where I input a conversion rate (say 1.50). I then have 4 columns (E to H), one for each of 4 currencies, one of which will populate using a formula based on the selections in A and B. So for example, if Column A selected I buy C$ and Column B selected US$, then Column E (which has my US$ values) would show the result of a formula multiplying 100,000 times 1.50. But I then want the other 3 columns to remain empty since the selections in A and B exclude them. Is there a simple way to do something like this? Thanks for any help!