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...