mulitple conditions in a formula

[GeekMan]

hi all

I hope I can make this clear...

I have a range of data in a drop down box that enters into column G, then generates a vlookup for column K of N or R or blank. However if column R has data = YES then column K must = N and I have worked a formula for this, BUT if one particular piece of data (one of the same incident) in column G is there then column K must stay blank even if column R = yes.

I have got an if formula that works if the G data (one of the same) and the R data (YES) are the same but that overides the ability to force the K column to N for all other data.

I essentially have to have a formula that allows multiple conditions is that right?

happy to upload the sheet if it helps

cheers

 

[Skybluekid]

Could you up load a sheet, to make it a bit clearer.

 

[GeekMan]

thanks skybluekid

it says I am not allowed to post attachments. is this an administrator issue?

 

[VoG]

You cannot attach a file but you can use one of these methods to post a shot of your sheet http://www.mrexcel.com/forum/showthread.php?508133-Attachments

 

[GeekMan]

ok converted it to HTML from the link now how do I post?

 

[VoG]

Click Reply to Thread then press CTRL + V to paste.

 

[GeekMan]

Excel 2002
	F
22
Aug

 

[GeekMan]

that does not seem to have worked sorry

I have the file converted on desktop as HTML from XLS. is that right?

 

[GeekMan]

Excel 2002
	F	G	I	J	K	L	M	N	O	P	Q	R	S	T
26			#N/A	#N/A	#N/A	###
27			#N/A	#N/A	#N/A	###
28			#N/A	#N/A	#N/A	###
29		MINOR FIRE	0	248	R	Y
30		MINOR FIRE	0	248	N	Y						YES
31		ONE OF THE SAME INCIDENT	#N/A	#N/A	#N/A	###
32		ONE OF THE SAME INCIDENT	#N/A	#N/A	N	###						YES
33			#N/A	#N/A	#N/A	###
34			#N/A	#N/A	#N/A	###
35			#N/A	#N/A	#N/A	###
36			#N/A	#N/A	#N/A	###
Aug

Cell Formulas
Range	Formula
I26	=VLOOKUP(G26,Data!$A$4:$G$54,2,0)
J26	=VLOOKUP(G26,Data!$A$4:$G$54,3,0)
K26	=IF(R26="yes","N",(IF(R26="",VLOOKUP(G26,Data!$A$4:$G$54,5,0))))
L26	=VLOOKUP(G26,Data!$A$4:$G$54,7,0)

Named Ranges
Name	Refers To	Cells
E	=Data!$Z$2:$Z$7
P	=Data!$Y$2:$Y$7
S	=Data!$AB$3:$AB$7
T	=Data!$AC$3:$AC$7
V	=Data!$AD$3:$AD$6
Yes	=Data!$Q$3:$Q$7

 

[GeekMan]

ok got it see last post for HTM post

row 29 data in column G = MINOR FIRE = this generates data R in column K.

row 30 we have had a use of force (column R) changing the data from R to N. this automatically changes any R data in column K to N for any incident (an overide)

row 31 is data 'one of the same incident' if multiple offendors are involved. normally no other vlookup data loads there

so now

row 32 I want to keep data YES in column R but have nothing in column K IF and ONLY if 'one in the same incident' is selected.

happy to explain further or in more detail

cheers