Multiple IF statement
 

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

Multiple IF statement
 

What's a line?

"Nikki" wrote in message
...
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

Multiple IF statement
 

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

"Tyro" wrote:

What's a line?

"Nikki" wrote in message
...
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

Multiple IF statement
 

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

On Feb 25, 5:40*am, Nikki wrote:
sorry i meant a certain cell that displays info dependant on what is chosen.

Multiple IF statement
 

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" wrote:

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

On Feb 25, 5:40 am, Nikki wrote:
sorry i meant a certain cell that displays info dependant on what is chosen.



"Tyro" wrote:
What's a line?

"Nikki" wrote in message
...
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- Hide quoted text -

- Show quoted text -

Multiple IF statement
 

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

On Feb 25, 8:27*pm, Nikki wrote:
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" wrote:
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

On Feb 25, 5:40 am, Nikki wrote:
sorry i meant a certain cell that displays info dependant on what is chosen.

"Tyro" wrote:
What's a line?

"Nikki" wrote in message
...
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- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -