Generate value based on various inputs

[mcbgun]

Hey guys,

I want to create a spreadsheet for a football game based on teamtalks. Below is a typical example output of what needs to happen:

Overall Teamtalk Squad Mood Match Odds Squad Morale Give talk

Pre-Match Complacent Favorite Good I expect a win


In the first two cells of the second row are values that are selected from a drop down list by the user. So when the user selects pre-match then complacent, then favorite, then good.....the value in the give talk cell should automatically produce I expect a win.

Basically I just want a template formula so that I can return a value based on a number of conditions selectable by the user through list box values. I've worked out how to create list boxes but have no clue about what formula to use.

Below is more detailed set of conditions with the give talk cell being generated by using the various values/strings combinations in the columns. In essence I'm guessing some sort of array needs to be set up so that when a certain combination
of options are selected, a specific string is produced for give talk based purely on what the user has selected for each list box:

Individual Teamtalk Score Half-time overall talk Morale Mood Player Rating Substitute? Squad Status Give talk

Half-Time Drawing Disappointing Good Normal 7.0-7.4 No Senior None

Any ideas peeps?

Cheers!

Mcbgun

[ozzie]

something like