I've been searching but can't find something that matches exactly what I'm trying to do.
I have sheet which contains a list of hotels. These hotels are repeated and black out dates are in another column sort of like so:
Charlotte - Airport South 05/26/17
Charlotte - Airport South 05/27/17
Charlotte - Airport South 05/28/17
Charlotte - Airport South 06/30/17
Charlotte - Airport South 07/01/17
Charlotte - Airport South 07/02/17
I have a second sheet with similar data.
I am trying to determine if THIS hotel with THESE blackout dates is present in both files. So in other words does this hotel's dates from file "A" exist in file "B"?
I tried vlookup but that's returning only the first date, which doesn't help. I considered conditional formatting, but I'm having trouble with that. Can anyone help? Thanks so much!
I have sheet which contains a list of hotels. These hotels are repeated and black out dates are in another column sort of like so:
Charlotte - Airport South 05/26/17
Charlotte - Airport South 05/27/17
Charlotte - Airport South 05/28/17
Charlotte - Airport South 06/30/17
Charlotte - Airport South 07/01/17
Charlotte - Airport South 07/02/17
I have a second sheet with similar data.
I am trying to determine if THIS hotel with THESE blackout dates is present in both files. So in other words does this hotel's dates from file "A" exist in file "B"?
I tried vlookup but that's returning only the first date, which doesn't help. I considered conditional formatting, but I'm having trouble with that. Can anyone help? Thanks so much!