Get instant live Excel expert help to learn how to add data validation in excel

I have an excel sheet with drop down menus in column a and b. Dependent on what you select from column a (1,2,3,4), when you go to column b it then gives you sub options to choose based on your previous option. I used data validation for column a but I'm stuck on how to apply the sub filter

im trying to add names in my cell and it is coming up with the data validation message.

Is there a way to automatically add a comment as part of data validation. For example, if 1 is selected, then show "Approved" as a Comment in the cell, if 2 is selected, then show "Rejected" as a comment. This is a simple example but basically, the text we'd like to show is quite long so would rather keep it as a comment vs. in the cell.

Im getting an error win data validation :value must match one of the listed items. When I attempted to recreate the table, I got the following error: "An invalid value was used while savint to WK 1 format

I'm using data validation to create a dropdown in excel, but there seems to be a maximum number of characters I can use? Any way around that?

Suppose a number, multiple of 10 between 10 and 90, is entered in cell A1. Your task is to set up a lookup table so that cell D1 displays in words the number entered in cell A1. For example, when number 10 is entered in cell A1, D1 displays "Ten" and it displays "Twenty" when 20 is entered in cell A1. Make sure to add data validation for cell A1 to flag invalid entries.

Can I create a default data validation within a cell. For example, I want the user to input a value into the cell but if they do now know they value, I want them to do excel select from list "Unknown" (using data validation). I want the default value to be "Unknown". Thanks for your help.

Hi, I am working on a Macro-enabled workbook and having issues with creating a data validation formula. This is my formula, and I cannot see what could be wrong with it, but I keep getting an error. =IF($C$7=DETAIL!$F$3,DETAIL!$C$3:$C$17,IF($C$7=DETAIL!$F$4,DETAIL!$D$3:$D$10,IF($C$7=DETAIL!$F$5,DETAIL!$D$31:$D$38,IF($C$7=DETAIL!$F$6,DETAIL!$D$11:$D$21,IF($C$7=DETAIL!$F$7,DETAIL!$D$22:$D$30,IF($C$7=DETAIL!$F$8,DETAIL!$E$3:$E$15,"")))))

How can I apply Drop down data validation to the same column on multiple sheets from a master 6x11 data table excel?

Working from an existing sheet with data validation rules attached, I have changed the list names that I want in my drop down list, but it is dropping down to the old list. How do I associate the new list titles to the drop-down cells?