I keep getting #Name? for the answer to the cell.

I am using the following formula.

=IF('MANAGER ONLY'!$D$3:$D$200=ADMIN,'MANAGER ONLY'!A$3:A$200,"")

I am using a dropdown box for Column D. In the drop down list there are multiple text in their such as ADMIN, MAINT ADMIN, ARO and so on. However, when I apply the text to the formula I get the #NAME? error. But if I use this formula like this:

=IF('MANAGER ONLY'!$D$3:$D$200=400,'MANAGER ONLY'!A$3:A$200,"")

It does exactly what I want it to do. So how do I allow the excel to accept the first formula with the text instead of the number? What do I need to do to allow the criteria to look up text?

Re: I keep getting #Name? for the answer to the cell.

Awesome thank you. Do you do this for all text?