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?