Hi all!
Any help with this would be greatly appreciated, as it's been a day now where I still haven't quite figured this out.
In my reference sheet, I have a column A for names, column B for timestamps, column C for ticket #, and so on.
In another sheet, I want to search for a specific name in column A and pull the adjacent timestamp from column B ONLY if the timestamp matches my wildcard criteria.
Reference sheet:
Name |
Timestamp |
Alex Smith |
Mar 18, 2019, 7 AM |
Alex Smith |
Mar 18, 2019, 7 AM |
Alex Smith |
Mar 18, 2019, 8 AM |
Alex Smith |
Mar 18, 2019, 9 AM |
Alex Smith |
Mar 18, 2019, 12 PM |
Alex Smith |
Mar 18, 2019, 12 PM |
Alex Smith |
Mar 19, 2019, 7 AM |
Alex Smith |
Mar 19, 2019, 7 AM |
Alex Smith |
Mar 19, 2019, 7 AM |
Alex Smith |
Mar 19, 2019, 9 AM |
Alex Smith |
Mar 19, 2019, 9 AM |
Alex Smith |
Mar 19, 2019, 1 PM |
Jennifer Lynch |
Mar 18, 2019, 7 AM |
Jennifer Lynch |
Mar 18, 2019, 8 AM |
Jennifer Lynch |
Mar 19, 2019, 7 AM |
Jennifer Lynch |
Mar 19, 2019, 12 PM |
Assuming I'm searching for "Alex Smith" in column A and "Mar 19, 2019*" in column B, this is what I expect my results to look like:
Results for Alex Smith:
Mar 19, 2019, 7 AM |
Mar 19, 2019, 7 AM |
Mar 19, 2019, 7 AM |
Mar 19, 2019, 9 AM |
Mar 19, 2019, 9 AM |
Mar 19, 2019, 1 PM |
I've gotten really close using the formula below, but unfortunately the wildcard doesn't work. ($A$2 is referencing a cell that includes "Mar 19, 2019".)
Thank you ahead of time for any and all help!
Bookmarks