I am not too swift with database functions so I am trying to do this problem with nested if, match or vlookups.
For example, I am trying to create a NHL schedule for fantasy teams.
on the vertical column (A) I have teams...horizontally across row 1 I have dates and for my table I have teams and dates and opponents.
My goal is to either start with the date and then look up the teams that play on that date....run a match with the players team and then determine the opponent if any.
I just need a little help with nested statements...I will continue to use the search function here, but if anyone can give me a leg up, I would appreciate it.
Thanks!
For example, I am trying to create a NHL schedule for fantasy teams.
on the vertical column (A) I have teams...horizontally across row 1 I have dates and for my table I have teams and dates and opponents.
My goal is to either start with the date and then look up the teams that play on that date....run a match with the players team and then determine the opponent if any.
I just need a little help with nested statements...I will continue to use the search function here, but if anyone can give me a leg up, I would appreciate it.
Thanks!