I need help with a if statement

[Legacy 420921]

https://1drv.ms/x/s!AnJwxxiz0Ezpg8c6oid-OUrUmz6fiw



I need help with a if statement in P16 answer show AWAY and P17 be HOME


Thanks You


Thomas

 

[Michael M]

Drag down as required

=IF(T16="@","AWAY","HOME")

 

[Legacy 420921]

ty very much. any possible can you look at my other posted?

 

[Legacy 420921]

I have it have look up opponents first on that formula

 

[Fluff]

Cross posted https://www.excelforum.com/excel-general/1277631-i-need-help-with-a-if-statement.html#post5128562

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.