Hi guys,
I am working on a cricket database spreadsheet. and i am facing a problem with index and match formula. please see the attched image you will understand. Excelforum help.JPG
as you can see in the image. i am using =INDEX(J5:Y5,MATCH(F5,J5:Y5,0)-1) to get value of the left cell of maximum wickets. it works fine in most cases but where in multiple matches wickets are same and runs are value are diffrent then it grabs only the first value. i need it to grab the minimum runs value of the most wickets.
hope i explained the problem clearly.
i am using office 2007.
Thanks
Bookmarks