Jan 15 2019 12:47 PM
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
Jan 15 2019 01:16 PM
SolutionHello
=INDEX($F$5:$O$7,MATCH(A2,$E$5:$E$7,0),B2)
Jan 15 2019 07:41 PM
Awesome - Thank You Lewin, Appreciate your support.
@Detlef Lewin wrote:Hello
=INDEX($F$5:$O$7,MATCH(A2,$E$5:$E$7,0),B2)
Jan 15 2019 01:16 PM
Solution