"The list source must be a delimited list or a reference to single row or column"

I have seeked help on this error before and got an answer but it was a work around and not an actual fix.

I am trying to use an 'IF' command within a Data Validation List command.

Please Login or Register  to view this content.

I have been using this kind of code for many years in many different spreadsheets and never had a problem but now, even for this very simple formula, I get the error MSG "The list source must be a delimited list or a reference to single row or column".

Error.jpg

I have also tried the following;

Please Login or Register  to view this content.

(1) Failed with the same error MSG
(2) Accepted

The data entry is on Sheet 1 and the validation section is a list of 3 letter - A, B & C, on Sheet 2.

Please can someone explain why I am getting this error all of a sudden - it may be something simple that I am missing.

2 things.

1. You have to make sure the data validation doesn't evaluate to an error 'at the time you enter the validation formula"
So make sure B2 IS = Windows 7 Depolyment 'At the time you enter the validation'

2. You're making the validation check for "Windows 7 Deployment", But the B2 cell has the formula
=IF($A2<>"","Windows 7 Deployment Team","")
They don't match....

so use =IF($B2="Windows 7 Deployment Team",Answer) in the validation AND make sure A2 is NOT blank 'at the time you enter the validation'

Thank you both .... Both suggestions worked, you don't know how much hair I've lost trying to work this out

Great, glad to help.