Forum Discussion
Solved
Question XLOOKUP finding the next match row if blank
Hi, Question: I have a data set which using XLOOKUP returns an email address for a customer number. ON the email data set, there are multiple emails for each customer number. How can I retur...
A couple of thoughts. An alternative to searching for concatenated conditions is to simply strike out the customers that do not have declared email from consideration. If there isn't an entry with an email, you could always relent and use the 'if not found' parameter to repeat the search to return such data that may exist.
= XLOOKUP( @selected, IF(email<>"", customer), email:phone )
or
= XLOOKUP( @selected, IF(email<>"", customer), email:phone,
XLOOKUP( @selected, customer, email:phone ) )Thanks PeterBartholomew1 - very helpful! Cheers
