I'm trying to look at a range of cells based on two criteria, date and team.
If both the date and team show up I want the opponent to show up. Not sure
how to use multiple vlookups for two criteria and if they both match bring
back the appropriate response. In addition I want the value to be null if
there is no match. Can anyone provide some thoughts. I've tried to use
multiple vlookups and if then statements but its not working.