IF , AND and OR formula help please

[DrH100]

I have a simple spreadsheet with 4 or five columns in.

Column A and B have data validation which the user will drop down

Column A = Team, Individual
Column B = Winner, Runner up, NA

What I am trying to do is in column E have a formula which looks for the results of A and B and inputs data accordingly from another sheet.

So far I have got

=IF(AND(b2="winner",A2="Individual"),CONCATENATE(Sheet2!A2,"",Sheet1!b2,"",Sheet2!C2))

which works fine for that bit but what I also need (and the bit where I get very confused with multiple IFs and ORs or ANDs) is the formula to return results if b2 = runner up and a2 = individual, b2 = winner and A2 = Team etc etc etc

The return from Sheet 2 will differ but I can do that bit.

If someone can show me how to link one more set of outcomes in I can probably work out the rest from there

Hope that makes some sense

 

[anglais428]

You just need to start a new IF in the false statement of the existing IF.
For example, between your last two brackets insert a comma and then start your next IF statement and so on.

=IF(AND(A2="individual",B2="winner"),CONCATENATE(Sheet2!A2,"",Sheet1!b2,"",Sheet2!C2),IF(AND(A2="individual",B2="runner-up"),"enter your true statement","start your next IF here"))