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

Did you buy anything on Amazon's Prime Day?

Discuss in The Lounge

Poll History