MAX value in worksheet2 col AK= value in other worksheet1 B24 and col AL in worksheet2 must = 500 - answer needed is value in worksheet2 colAE - All will be in same row of worksheet2 (problem has been that there are 2 instances of max val in worksheet2 col AK which are the same, but only 1 of them has worksheet2 val AL=500)

Please make believe that you are one of us sitting out here on the interweb having no idea what you are trying to accomplish. Then read your post and see if it makes sense to you. Perhaps if you reposted your question with proper punctuation between the sentences and an example of your data it would be easier to understand.

Please click on the following line and read the instructions found via that link before posting example data. Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

DerbyDad03 your point is taken is this better? I want to find the highest number of darts (total darts) where there was a win (total darts = 501) and return the Shot Out value - In the example Row 5 would be the one with the correct value of 3 Shot Out 45 total darts & 501 total scored The problem is to find the value of the MAX K3:K6 where L3:L6=501 & return the value of E3:E6 from that same row,(formula shown at the end finds the 1st instance of max K3:K6, but does not look for the value 501 in L3:L6 How can the formula be changed to do this please? Player9 Worksheet E F G H I J K L Shot Number count Non Out Leg Av total total Out Darts zeros Zero Shortfall darts scored xthree Av 3 16 2 3 19.27 0 51.83 29 501 4 9 13.81 4 33.13 45 497 5 3 3 0 11.13 0 33.40 45 501 6 10 1 6 14.74 0 37.58 40 501 Summary Worksheet B C D Player Highest Shot out # Darts In Game 33 Wiz 45 0 The 0 in D33 above should be 3 - The formula used in D33 is :- =INDEX(Player9!$AE$3:$AE$65,MATCH(MAX(Player9!$AK$3:$AK$65),Player9!$AK$3:$AK$65,0))

Ask Your Question

Weekly Poll