SheetsdrillNext sailing on or after a date
A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Sailings are listed with their dates. Return the vessel of the first sailing on or after the ready date in F1, using XLOOKUP. Answer in F2.
What this exercise teaches
Match mode -1 rounds down to the previous item and 1 rounds up to the next one. Neither needs a sorted list, which is why XLOOKUP replaces the old approximate VLOOKUP for this job.
A hint if you get stuck
XLOOKUP's 5th argument is the match mode. 1 means exact match or the next larger item. Leave the 4th argument empty with two commas in a row.
Try it now, free, no account needed
The first 15 tasks on Sheetsdrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro adds timed mode and the certificate.
Open this exercise