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...
Hi Sergei, I'm trying to use the Xlookup method so that I can reverse the search order. It works in Excel, but not Google Sheets. I'm guessing it has to do with the way arrays are handled. Any thoughts?
I'm not familiar with Google Sheets, but it looks like last-to-first works in it