Try

=if(L8="","",if(L8<1,"",vlookup(L8,Command,2,False )))


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"jimar" wrote in message
...
I have a named ranged that has section numbers or letters in the first
column
and Command Names in the second column ie
1 = Command 1
2 = Command 1
BNRP = Command 3
ACM = Command 4
I am using a formula that when the user types a member of staffs payroll
number their relevant section appears in one column ie 1,2,BNRP or ACM and
the corresponding command name is displayed in another column. This works
perfectly for all sections with numbers or letters except for section ACM
when N/A is displayed in the cell. If the A is removed from the section
name
and just CM is left the formula works. Put the A back in and the formula
stops working. The formula I'm using is
=if(L8="","",if(L8<1,"",vlookup(L8,Command,2)))
Any help would be appreciated.
Thanks