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
Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Similar threads
- Question
- Solved
- Question
- Solved
