I'm doing an excel spreadsheet on sports and I want to compare two values in different columns and then I want this formula to give me the team's name in next column example

a1 b1 c1 d1

chicago 100 NY 90 I want the formula to give me Chicago in E1

Even though you didn't say it, I assume you want Chicago in E1 because their score is higher. I also assume there will never be a tie. =IF(B1>D1, A1, C1)

Click Here Before Posting Data or VBA Code --->How To Post Data or Code.

Thank you so much derbydad you assumed it right!! Thanks!

Is it possible to make a standings chart with the formula you helped me before. Something that updates when I type in the results of the game.....and adding wins and losses thank you.

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History