Hi.
I would like to use XLookup to return a date from a table on Sheet 2 based on an ID entered into the table on Sheet 1. The issue is that the dates populate two different columns and must remain that way. If the Date 1 column is blank I would like xlookup to pull the data from the Date 2 column instead. The attached sheet will demonstrate the requirement.
Thanks in advance.
Bookmarks