mulitple conditions in a formula

GeekMan

New Member
Joined
Jul 1, 2012
Messages
17
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:eek:
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Could you up load a sheet, to make it a bit clearer.
 
Upvote 0
thanks skybluekid

it says I am not allowed to post attachments. is this an administrator issue?
 
Upvote 0
that does not seem to have worked sorry

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

Excel 2002
FGIJKLMNOPQRST
26#N/A#N/A#N/A###
27#N/A#N/A#N/A###
28#N/A#N/A#N/A###
29MINOR FIRE0248RY
30MINOR FIRE0248NYYES
31ONE OF THE SAME INCIDENT#N/A#N/A#N/A###
32ONE OF THE SAME INCIDENT#N/A#N/AN###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
RangeFormula
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
NameRefers ToCells
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,211,686
Messages
6,103,297
Members
447,853
Latest member
olddutch7

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top