lookup a value in a range in excel where search depends upon 2 constraints

How about this?
PL of 12-13 v1-q.xlsx

try this forumla and copy down

=INDEX($G$4:$M$10,MATCH(C2,$G$5:$G$10,0),MATCH(B2,$H$4:$M$4,0))

In D2

=INDEX($H$5:$M$10,MATCH(C2,$G$5:$G$10,0),MATCH(B2,$H$4:$M$4,0))

Copy down

HI Anibha,

Use below formula and drag down:-

Formula:

=INDEX($G$4:$M$10,MATCH($C2,$G$4:$G$10,0),MATCH($B2,$G$4:$M$4,0))

Regards,
DILIPandey
<click on below * if this helps>

Everybody is pushing for Index formula....
Is there any reason for that?
What about using Vlookup or the formula I have used...

PHP Code: 

=OFFSET($G$4,MATCH(B2,$G$4:$M$4,0),MATCH(C2,$G$4:$G$10,0)) 


Hi akhileshgs,

There could be reasons for that but as per me why I chosen Index -match because it is faster then vlookup

Hope thread will not change towards the discussion of "which formula is fast" as we all can do separate research on that

Regards,
DILIPandey
<click on below * if this helps>

Cheers


Please mark this thread as [SOLVED].. thanks.

Regards,
DILIPandey
<click on below * if this helps>

Sorry Pandeji.....

____________________________________


To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

Its Ok AkhileshJi


Regards,
DILIPandey
<click on below * if this helps>