locked
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

Answers

  • Re:  Look across and up

      =INDEX(A1:D2,1,MATCH(B8,A2:D2,FALSE))

      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