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...