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
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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies