pencil_pusher
New Member
- Joined
- Apr 19, 2009
- Messages
- 6
I want to know if the time in sheet1 A2 matches any time (plus or minus 12 hours) in sheet2 A2:B546, if so, then return the value for sheet2 A2. I'm getting hung up on the "plus or minus 12 hours". Can I use vlookup for this or will it not work because the range does not consist of single values?