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 struggling with this one!

Please see attached example which will explain it better!

Thank you for your help!

​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 struggling with this one! Please see attached example which will explain it better! Thank you for your help!  Read More

​