find value in column if 2 other columns meet criteria

May 27, 2013 at 06:18:45
Specs: Windows XP
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)

See More: find value in column if 2 other columns meet criteria

Report •

May 27, 2013 at 08:53:30
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.

Report •

May 28, 2013 at 04:02:08
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 :-


Report •

Related Solutions

Ask Question