Forum Discussion
Two Way Lookup
Hi all, I am getting myself confused on this one - how can I return the corresponding name for a match based on the horizontal header and a non empty cell? I know how to do a one way lookup, but...
I have added the formula in Column D.
LET(data,XLOOKUP($D$10,$B$1:$K$1,$B$2:$K$7),FILTER($A$2:$A$7,data<>0))
- I think the issue is with my imported dataset. Please see other thread
