IF STATEMENT BASED ON EQUAL VALUES IN RANGE

[mrmmickle1]

Here is a sample spreadsheet. I was almost able to get it to work by adding a few helper columns. I tried to write a function called LookupWinner but I couldn't get it to work correctly. This spreadsheet is nothing crazy. Just a few drop down list boxes and nested if statements. It should be pretty self explanatory... I think I may have forget to take protection off the work book. Just use 1234 as the PW.