Try this,
=INDEX($G$4:$K$5,MATCH(B2,$F$4:$F$5,0),MATCH(B3,{0,201,500,1000,2000},1))
You can type the hours range on cells G1 thru K1 and the formula will look like this
=INDEX($G$4:$K$5,MATCH(B2,$F$4:$F$5,0),MATCH(B3,$G$1:$K$1,1))
Regards
Try this,
=INDEX($G$4:$K$5,MATCH(B2,$F$4:$F$5,0),MATCH(B3,{0,201,500,1000,2000},1))
You can type the hours range on cells G1 thru K1 and the formula will look like this
=INDEX($G$4:$K$5,MATCH(B2,$F$4:$F$5,0),MATCH(B3,$G$1:$K$1,1))
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks