Drop down boxes with conditions and IF formulas

[MonkeyFace28]

Hi all,

I really didn't know what to put the title of this as because they are soo many things to do in this spreadsheet I don't really know where to start!

I have a workbook that has 3 different drop down boxes and all 3 have different results!

first question is: I have a Country drop down, which brings in a total, depending on the country selected see formula below
=IF(Calculator!$C$6="UK/Europe",'Solution Set - All'!$I$28,IF(Calculator!$C$6="CHINA",'Solution Set - All'!$L$28,IF(Calculator!$C$6="HONG KONG",'Solution Set - All'!$O$28,IF(Calculator!$C$6="JAPAN",'Solution Set - All'!$R$28,IF(Calculator!$C$6="KOREA",'Solution Set - All'!$S$28,IF(Calculator!$C$6="MACAU",'Solution Set - All'!$T$28,IF(Calculator!$C$6="RUSSIA",'Solution Set - All'!$U$28,IF(Calculator!$C$6="INDIA",'Solution Set - All'!$V$28,IF(Calculator!$C$6="USA",'Solution Set - All'!$W$28," ")))))))))
The only thing on this I need help with, is changing the currency when the country is selected?

Next:
if the client selects "YES" in the next drop down box, I need it to pull information in from a certain section BUT when the person adds quantities it needs to select different components... here is the brief from guy, hope it makes sense:

* if yes, then the Calculator needs identify that a DM matrix will be required
- subject to the qty of screens it will automatically select the size of chassis and the type/qty of DM cards etc
Flagship switching:
- if 'Flagship' is selected, then the Calculator needs to auto factor in the DM element (solution set starting line 482 on next tab)
- base line position is that everything already with a qty remains unchanges throughout
- the variable on top of this are:
- with every screen selected (excluding WayFinding), the Calculator needs to auto add x1 DMC-HD and x1 DM-RMC-100-S
- when between x1 and x4 screens selected (excluding Way Finding), the Calculator needs to auto add x1 DMCO-44
- then if a 5th - 8th screen is added (excluding Way Finding), the Calculatir needs to auto selected a further x1 DMCO-44 (and continues adding, as additional screens area added)
- if the total qty of screens selected (excluding Way Finding) is:
- 0-7, the Calculator needs to auto select DM8X8
- 8-15, the Calculator needs to auto select DM16X16
- 16-31, the Calculator needs to auto select DM32X32
- 32-63, the Calculator needs to auto select DM64X64

<colgroup><col><col></colgroup><tbody>
</tbody>

there are quite a few different variables in this and I'm not even sure if it can be done!?

please someone help!

 

[MonkeyFace28]

**** bump *****