Forum Discussion
Solved
Looking up values and skipping blank cells
Hi, I have a set of customer data where each customer occurs in multiple rows (one row for each product that they have bought). In most cases, only one of the product rows has the customer ID. I...
CWI_AK
As you like Customer Id to return =INDEX([ID],XMATCH(1,([Customer]=[@Customer])*([ID]<>""))) this would be fine. To make it dynamic use table
CWI_AK
As you like Customer Id to return =INDEX([ID],XMATCH(1,([Customer]=[@Customer])*([ID]<>""))) this would be fine. To make it dynamic use table
bovasclion Thanks. This works fine!
SergeiBaklan Thanks again, should have been intuitive for me to switch out customer and id in the formula but couldn't get it to work on my own