SOLVED
Home

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

Jays_407
New Contributor

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 Replies
Highlighted
Solution

Hello

 

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

Awesome - Thank You Lewin, Appreciate your support.


@Detlef Lewin wrote:

Hello

 

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

 

Related Conversations
formula for data calculation
aayushman_mishra in Excel on
10 Replies
Creating A Sublist
zjohnson in Excel on
5 Replies
Excel Forumla to exclude empty cells.
ulken2019 in Excel on
6 Replies
Need FORMULA help please!!
marislav in Excel on
4 Replies