data validation vlookup

  1. N

    Multiple Data Validation on one cell

    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...
    • NateCaruso
    • Thread
    • data validation data validation list if data validation macro data validation rule data validation vlookup
    • Replies: 2
    • Forum: Excel Questions
  2. H

    Change value in cell which was selected from dropdown list to another value

    I have a worksheet with a data validation dropdown list which the users will select from. The values contained in the dropdown list are the short (i.e. "user-friendly") descriptions of the values in a larger list. What I'd like to do is, when the user has selected the value they want from the...
  3. F

    validation list

    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...
    • Forestq
    • Thread
    • data vaidation data validation condition data validation list if data validation vlookup validaiton
    • Replies: 1
    • Forum: Excel Questions
  4. C

    Need help determing functions, programming needed for Worksheet (to help a cancer patient)

    <tbody> First of all, thank you in advance for your help with the four questions I have below! Background: I am trying to help a doctor communicate to a cancer patient about her medications, and for the patient to have a worksheet to check off all the meds she is supposed to take each time of...
    • carolbien
    • Thread
    • data validation vlookup filtering dynamic data linking data worksheets pivot automation
    • Replies: 2
    • Forum: Excel Questions
  5. C

    Linking multiple drop down boxes with multiple ranges using data validation...Errors.

    I'm having issues: I have dropdownboxeslinking different sheets within the same workbook and they are dependent on each other. Example: When you select Option A in F4 (dropdown box), subsequently the adjacent dropdown box, F5, should list options under the name Red (RedA, RedB, RedC) as well...
    • cool1_boy1
    • Thread
    • data validation condition data validation merger data validation vlookup drop down box link boxes drop down filter
    • Replies: 0
    • Forum: Excel Questions

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