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.