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
PeterBartholomew1 , thank you for the correction.
More legacy way
= LOOKUP(2,1/(@[Customer]=[Customer])/([ID]<>""), [ID] )