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

 

[GeekMan]

Bump - anyone ?

 

[GeekMan]

no one?

 

[GeekMan]

 

[Skybluekid]

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

I think I know what you are looking for

Am I right i saying that if there is a YES in R then there should be nothing in K?

 

[GeekMan]

thanks skybluekid

you're on the right track but in summary

YES in column R forces "N" in K (this bit already set) >> UNLESS G = 'ONE OF THE SAME INCIDENT" in which case I want nil or N/A in column K

 

[Skybluekid]

Try this

K32 =IF(R32="Yes","N",(IF(R26="",VLOOKUP(G26,Data!$A$4:$G$54,5,0),(IF(G32="ONE OF THE SAME INCIDENT","N/A")))))

 

[GeekMan]

the formula needs to look at data in the same line sorry - may have confused with my paste....

try again ---

same row only

if data in column R = YES and data in column G = one of the same incident then k = n/a otherwise any other data in column G uses the VLOOKUP or YES in column R forces N in column K

 

[Skybluekid]

K32 =IF(AND(R32="Yes",G32="ONE OF THE SAME INCIDENT"),"N/A",(IF G32<>"ONE OF THE SAME INCIDENT",VLOOKUP(G23,Data!$A$4:$G$54,5,0),(IF R32="Yes","N")))))

I think this is what you require. you might need to check the number of brackets.

 

[GeekMan]

getting close

your formula when entered had errors but got this to run without them

=IF(AND(R32="Yes",G32="ONE OF THE SAME INCIDENT"),"N/A",IF(G32<>"ONE OF THE SAME INCIDENT",VLOOKUP(G32,Data!$A$4:$G$54,5,0),IF(R32="Yes","N")))

but it does not do the force N into column K if column R = YES

sorry if my corrections have ruined the logic of your formula

 

[GeekMan]

no further thoughts skyblue?