Nested or formula combinations

LizzyG

New Member
Joined
Jun 15, 2021
Messages
4
Office Version
  1. 365
Platform
  1. Windows
Hi Guys,

Columns B, C, D, and E contain a list look-up (Yes or No)
Earlier today, you guys helped me that if column B and/ or E has "Yes", to return certain text (Thank you!)
I placed the updated functionality in column F.

Then I wanted the user to identify the scope of work based on the input provided. A "Yes" answer in columns B and/ or E would require one set of docs while
a "No" answer in columns C and D would require a second set of docs.
I could not figure out how to combine the two scenarios, so I merged columns A-F from two rows into one row and
then I added =IF(OR(B17="No",C17="No",D17="No",E17="No")," ","Update docs")

However, Would like to address a couple of things and need your help.
1. Is it possible to combine/ nest the documents (column G) needed based on the input validation (columns B-E)? If so, can you help?
2. If columns C or D contain a "Yes", I would the validation statement to be true (and right now it is not robust enough only some rows are true
3. Can the cells in column F and G remain blank (not visible) if any/ all the data in columns B, C, D, or E are blank?

Thanks,
LizzyG

Cell Formulas
RangeFormula
F2,F4,F6,F8,F10,F12,F14,F16F2=IF(OR(B2="Yes",E2="Yes"),"Yes","No")
G2,G4,G6,G8,G10,G12,G14,G16G2=IF(F2="Yes","SOP Updates, UnitOps Updates, Check User Group Permissions"," ")
G3,G5,G7,G9,G11,G13,G15,G17G3=IF(OR(B2="No",C2="No",D2="No",E2="Yes")," ","Complete the Req for Modification Form, Master Data Document, and Configuration Specification")
Cells with Data Validation
CellAllowCriteria
B2:E17ListYes, No
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,224,856
Messages
6,181,428
Members
453,040
Latest member
Santero

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