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))
Hi Tejas - great method however the list always includes the first result as "0"
| 0 |
| Elliott |
Can this be removed?