lookup value

General Excel Questions & Answers

2 Posts

2 Users

0 Reactions

243 Views

RSS

mey tithveasna

(@meytithveasna)

Posts: 70

Estimable Member

Topic starter

Hi expert,

I Need your help to look up values base upon two criterias as in attach filed

Thanks

Posted : 18/05/2017 5:15 am

SunnyKow

(@sunnykow)

Posts: 1417

Noble Member

Try this

=INDEX(A1:G5,MATCH(K2,A1:A5,0)+1,MATCH(J2,A1:G1,0)+1)

Sunny

Posted : 18/05/2017 11:32 am

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed