Data Validation List & nested IF using Named Ranges: still getting 'The list source must be a delimited list, or a refernce to a single row or column"

[ATKT]

hello,

I am using a data validation list with the following formula:

=IF($C$6="Administrative Assistant</SPAN></SPAN>",AASI1,IF($C$6="Regional Program Advisor",RPASI1,IF($C$6="Regional HR Liaison",HRLSI1,IF($C$6="Financial/Administrative Assistant",FAASI1,""))))

I am getting the error message "The list source must be a delimited list, or a refernce to a single row or column".

Other nested IF statements are working on different worksheets within the same workbook:
e.g. =IF($C$6="Regional Financial Support Officer",FSOSI1,IF($C$6="Financial Analyst",FCoordAnaSI1,IF($C$6="Financial Coordinator",FCoordAnaSI1,IF($C$6="Financial/Administrative Assistant",FAASI1,""))))*excel 2010

 

[marious]

hello,

I am using a data validation list with the following formula:

=IF($C$6="Administrative Assistant",AASI1,IF($C$6="Regional Program Advisor",RPASI1,IF($C$6="Regional HR Liaison",HRLSI1,IF($C$6="Financial/Administrative Assistant",FAASI1,""))))

I am getting the error message "The list source must be a delimited list, or a refernce to a single row or column".

Other nested IF statements are working on different worksheets within the same workbook:
e.g. =IF($C$6="Regional Financial Support Officer",FSOSI1,IF($C$6="Financial Analyst",FCoordAnaSI1,IF($C$6="Financial Coordinator",FCoordAnaSI1,IF($C$6="Financial/Administrative Assistant",FAASI1,""))))*excel 2010

=IF($C$6="Administrative Assistant","AASI1"........ and so for