Reverse HLookup RRS feed

  • Question

  • hello folks,

    Is it possible to formulize reverse HLOOKUP as following:

    In B5, I can use HLOOKUP to get the value in Row 2.

    But can I do the other way around, define value in B8 and B9, and get the label in Row 1?

    I tried: =HLOOKUP(B8,A1:D2,2) and it returned me #N/A

    Tuesday, January 7, 2014 2:03 AM


  • Re:  Look across and up


      returns "D"
    Jim Cone
    Portland, Oregon USA
    https://goo.gl/IUQUN2 (Dropbox)
    (free & commercial excel add-ins & workbooks)

    Tuesday, January 7, 2014 3:11 AM