Lookup on Multiple Criteria

[Admin]

Hi RK,

Anoher one..

In F2 and copied down and across,

=LOOKUP(2,1/((Grid!$A$2:$A$25=$B2)*($C2>=Grid!$B$2:$B$25)*($C2 <=Grid!$C$2:$C$25)*($D2>=Grid!$D$2:$D$25)*($D2<=Gr id!$E$2:$E$25)*($E2>=Grid!$F$2:$F$25)*($E2<=Grid!$ G$2:$G$25)),Grid!H$2:H$25)


Using INDEX/MATCH

=INDEX(Grid!H$2:H$25,MATCH(1,IF((Grid!$A$2:$A$25=$ B2)*($C2>=Grid!$B$2:$B$25)*($C2<=Grid!$C$2:$C$25)* ($D2>=Grid!$D$2:$D$25)*($D2<=Grid!$E$2:$E$25)*($E2 >=Grid!$F$2:$F$25)*($E2<=Grid!$G$2:$G$25),1),0))

It's an array formula. Confirm with CTRL + SHIFT + ENTER, not just ENTER.

[ramakrishnan]

Sir, It is really excellent !!!!!!!!!!! Thanks a million !!!! The formula is very much useful which will same much of my time,

Thanks very much.........

This forum is really good as i have become a freequent visitor. The solutions are received quickly . Thanks for the quick response.

Regards
R.Ramarishnan