Hello,
Is it possible to do an xlookup using two return array columns? Or, if there is a better solution please let me know.
For my spreadsheet, I have two tabs. I am doing an xlookup on the first tab to find a project number on the second tab, then I want to pull the milestone date from column G (actual date) unless it is blank, then I want it to pull the date from column H (projected date). FYI, sometimes both columns are blank.
Here is my formula, which is lacking sophistication since it's not working. When G has a value, it returns false instead of a date. When H has a value the formula returns the date.
=IF(XLOOKUP([@Project],Export!$A$2:$A$100,Export!$G$2:$G$100)=0,XLOOKUP([@Project],Export!$A$2:$A$100,Export!$H$2:$H$100))
Thank you, I appreciate any help I can get.
Is it possible to do an xlookup using two return array columns? Or, if there is a better solution please let me know.
For my spreadsheet, I have two tabs. I am doing an xlookup on the first tab to find a project number on the second tab, then I want to pull the milestone date from column G (actual date) unless it is blank, then I want it to pull the date from column H (projected date). FYI, sometimes both columns are blank.
Here is my formula, which is lacking sophistication since it's not working. When G has a value, it returns false instead of a date. When H has a value the formula returns the date.
=IF(XLOOKUP([@Project],Export!$A$2:$A$100,Export!$G$2:$G$100)=0,XLOOKUP([@Project],Export!$A$2:$A$100,Export!$H$2:$H$100))
Thank you, I appreciate any help I can get.