Hi I need help filling out the highlighted colum. The goal here is to fill out in Sheet 1, Column C "Closest After Dates in B", with the closet date after column B "Date signed up" by vlooking up to sheet 2 column B "Time", with criteria that Type is either "email", "outbound" or "inbound". I am doing this in google sheets not excel! Thank you for all your help.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Vlookup help finding closest date after reference date
Hi I need help filling out the highlighted colum. The goal here is to fill out in Sheet 1, Column C "Closest After Dates in B", with the closet date after column B "Date signed up" by vlooking up to sheet 2 column B "Time", with criteria that Type is either "email", "outbound" or "inbound". I am doing this in google sheets not excel! Thank you for all your help.
Excel Facts
Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Similar threads
- Question
- Solved
- Question
- Solved
