Forum Discussion

jcbuc78's avatar
jcbuc78
Copper Contributor
Apr 26, 2019

Excel help

Hello Excel experts

I need some help, been pluging around on google for hours and while got it close to work, can't get this nailed down.

See attached file

For column A:B, I am looking to input a formual in column E through H to caputre each example in column A:B

 

I had tried to create a drop down list for each header, then do an array lookup, was semi sucesful but could not get it to ignore duplciates.

 

Hope the above + attachment makes sense :) 

 

excel

5 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Apr 26, 2019
    In F2, you may use this formula, copied down rows and across columns:
    =INDEX($B:$B,
    MATCH($E2,$B:$B,0)+
    MATCH(F$1,$A$3:$A$6,0))
    • jcbuc78's avatar
      jcbuc78
      Copper Contributor
      Apr 27, 2019

      Thank you for helping, here is the screen shot of what is happing

      Twifoo 

       

      • Twifoo's avatar
        Twifoo
        Silver Contributor
        Apr 28, 2019
        The formula I suggested presupposes that E2 contains the lookup_value. You deleted the lookup_value, thereby effectively making blank cell as the lookup value.
    • jcbuc78's avatar
      jcbuc78
      Copper Contributor
      Apr 27, 2019

      Twifoo 

      If paste in exaclty as is, I think it not looking at the right cells.

      example, shouldn't the formual start in column E2 not F2?  Should be matching stating at A2 not A3, see the screen shot attached of what happens when pasted as is. 

Resources