Multiple IF statement

[Nikki]

Hi,

I have a series of drop down boxes and then a line at the bottom of the
spreadsheet that has a different code generated depending on what has been
chosen in the drop down boxes. Is a multiple IF statement the best way to do
this and if so can i please get some advice on this?

Thanks

 

[Tyro]

What's a line?

 

[Nikki]

sorry i meant a certain cell that displays info dependant on what is chosen.

 

[Pete_UK]

You will need to give further details. How many drop-down boxes do you
have, and what is in them? You might be able to use a multiple IF
statement, but it might be that VLOOKUP is more appropriate, depending
on the number of choices you have. More details please.

Pete

 

[Nikki]

Hi,

Ok so here goes -

First drop down box (Company) - looks up options from sheet 'Backend'
Second drop down box (Division) - looks up options from sheet 'Backend'
Third drop down box (Profit Centre) - looks up options from sheet 'Backend'
Forth drop down box (Project Type) - looks up options from sheet 'Backend'

Cell Project Number - 3 letter code generated depending on what options are
chosen in drop down boxes 'Company' 'Division & 'Project Type'

Please let me know if you need any more info.

Thanks

 

[Pete_UK]

How is your code made up? First letter of Company, Division and
Project Type? Or is it more complex than this?

I suspect that you will need to compile the list of codes in a table
of all possible choices (perhaps located in the sheet Backend), and
then you can look up the value from that table.

Hope this helps.

Pete