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

[Jays_407]

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 

[#2 · Accepted solution]

Hello

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

[#3]

Awesome - Thank You Lewin, Appreciate your support.

---

@Detlef Lewin wrote:

Hello

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

---