Forum Discussion

Jays_407's avatar
Jays_407
Copper Contributor
Jan 15, 2019
Solved

Please advise best function or formula to fetch the "Expected results" Column D

Please advise best function or formula to fetch the "Expected results" in Column D from the lookup data in the attached spreadsheet. Appreciate your help. Thx JS 
excel
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Jan 15, 2019

    Hello

     

    =INDEX($F$5:$O$7,MATCH(A2,$E$5:$E$7,0),B2)
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jan 15, 2019

Hello

 

=INDEX($F$5:$O$7,MATCH(A2,$E$5:$E$7,0),B2)
  • Jays_407's avatar
    Jays_407
    Copper Contributor
    Jan 16, 2019

    Awesome - Thank You Lewin, Appreciate your support.

    Detlef_Lewin wrote:

    Hello

     

    =INDEX($F$5:$O$7,MATCH(A2,$E$5:$E$7,0),B2)

     

Resources