Data Validation Error

[piperjo]

I am trying to create a drop down for scheduling and I want it to hide names once they are clicked. I have followed all the instructions to a T. Once I get to the validation and enter the name range I get the error "Source currently evaluates to an error. I have window 10pro I am not sure what to do next.

 

[piperjo]

It is giving me the same error and I started a completely new spreadsheet.

 

[piperjo]

When I get to the validation part if I don't put in the = sign I get a drop down that gives me the name range but no names. If I put the = sign in I get the error.

 

[jasonb75]

Do you have a list of names in B2:B51 that is identical to the list in A2:A51?

It is giving me the same error and I started a completely new spreadsheet.

Note that the formulas in post 10 are based on the information in post 9. You said that the name of the sheet was 'Sheet' so that is what I have used. Unless you have changed it, there will be a number after 'Sheet'. If the formula says 'Sheet' when your sheet is actually 'Sheet1' then that will cause the error that you describe.

 

[piperjo]

So if I am just using column letter then I don't need the "sheet" just the column letter?

 

[jasonb75]

You need all of it.

Sheet name, exclamation mark, dollar symbol, column letter, dollar symbol, row number, colon, dollar symbol, column letter, dollar symbol, row number.

Sheet1!$B$2:$B$51

If you do it without the sheet name then it will automatically use the sheet that is selected (the one that you can see behind the named range box).