data validation list if

Hello, I am trying to make an ifs statement that works with data validation. I want it to be IFS(A1="Location1","Fred",A1="Location2","Mike",A1="Location3", *drop down of 3 names*) (If A1= Location 1 then A2 autopopulates to Fred, same with location 2 and Mike, Location 3 I want a drop down of...

Hi I have a rules database 4 columns, circa 500 rows(all cells populated). Column D has ALL unique values(the rules) Column A 37 unique values,B and C similar(the descriptors). If you want to find a rule in column D you use A-C to narrow down the search. Easy with filters, but I want to build...

I have a table with the following columns: Account, Sub, and Split. I'm trying to create cascading data validation lists where you first select the Account, then the Sub, and finally the Split. So in the table below if I chose Account = 501650, then Sub = 00-240, the third Split list should...

I am filling out a list of capabilities that have sub-capabilities. A2 is the Capabilty Name A3 is the Sub-Capability name B2 is drop down list (data validation ) with selections of "Yes", "No", or "N/A" In B3 I am trying to create an IF Statement where if B2="YES" then I am presented with a...

I am filling out a list of capabilities that have sub-capabilities. A2 is the Capabilty Name A3 is the Sub-Capability name B2 is drop down list (data validation ) with selections of "Yes", "No", or "N/A" In B3 I am trying to create an IF Statement where if B2="YES" then I am presented with a...

I'm building out a form where I'd like a cell to either be unusable or have a dropdown list available depending on the input in the row. So the example is if the user in cell A3 selects "Yes" I want cell B3 to be unusable similiar to this function =A3<>"Yes". But if the user in cell A3...

Hi Guys, I currently have an order sheet for multiple customers. The AC Number goes into Sheet1 C2 and you select the product type from a drop down list in C3(the information for the list is on sheet 2 H2:H6 . ) my problem is that no matter which ac number goes into c2 you can still see all...

Hello, Is it possible to enable a data validation list based on a cell's true false value? Thank you!

hello everybody, I want to get a data validation list in dress form sheet in cell J1 after choosing a fixed condition in cell H1. I have created a formoula in sheet2 but it dosent work as I paste it in data validation options list of refer to box. pls help me to get the right formula which I...

Hello I created a list data validation to a range of cells using =INDIRECT(SUBSTITUTE($D3," ","_")), and it works great, I do understand that there is a limitation that data validation only works with user enter values, however I need to populate the range with a Copy/Paste, so what I need, if...

Hi Members, I'm trying to pull out a validation list based on a if statement, with the following code Sub ValJBA() Dim i As Long Dim sList As String Dim dv As Validation Dim wks As Worksheet Set wks = Sheets("JBA - SpaEn") If wks.Range("C23") = "Intercompany" Then sList =...

hi, in Sheet2 I have list: <tbody> columnA (name) ColumnaB (region) Audi Euro Ford USA Chevi USA VW EURO Porshe EURO </tbody> I used manager name to define range: Cust_Name = Sheet2!$A:$A Reg_Name = Sheet2!$B:$B Now, in Sheet1 I did data validation and I have: A2 = list of name...

I am trying to restrict certain dates in a cell using the following custom Data validation formula if(H2=12/10/2013,12/25/2013,False) But unable to achieve the desired result. i am sure there is a problem in formula. Can some one please correct the formula.

Hi, I have an automatically updated list going down a column. (100 rows in the column have a formula and it is basically saying it equals the next figure in the list that has been selected until there are no others and it then =""). =IF(ROWS($L$3:L3)<=(COUNTIF('Purchases...

This one field is invalid if the other field does not say Web only or Both. I have a Name Range called WebCatListing that I want to display but only if one of these two options are checked. Here is what I have: =IF(OR(Q20 = "Both", Q20 = "Web only"),WebCatListing,"") Thanks

If value of cell A1 is "a", then I want data validation (list of choices) for cell B1. If value of cell A1 is "b", then any value can be entered into cell B1. Data validation doesn't automatically support this. How to do this?

Hi Team, Hope can anyone help on the below request. I have two data validation columns and I would to get the second validation based on first selection. Expecially if I select "No" in first column (A2) then in B2 data validation should not require to appear the drop down. It should block...

hello everyone, please any one help me for Data Validation List working with IF Condition in VBA? if Sheet1 A1=1, B1=1,2,3 (1,2,3 come from Sheet2) or A1=2, B1=A,B,C (A,B,C come from Sheet2) with ignore BLANK CELL m need 13 different value in A1 n 13 Data Validation in B1 like above this