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.


    ADMIN, MAINT ADMIN etc should be in quotes otherwise Excel will treat them as named ranges.


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

    Boo!:yikes: