Text should be in quotes.

=IF('Settlement Sheet'!D9="deb",'Settlement Sheet'!B9,0)

"Morris" wrote:

I have a workbook in excel 2002 that has several worksheets within. There is
the first sheet into which all the data is imputed. each other sheet refers
to a staff member whose function is actioned on the first sheet.
At the moment I am useing an "if" formula eg
=IF('Settlement Sheet'!D9=1,'Settlement Sheet'!B9,0)
this takes the date on sheet 1 and places it into the appropriate sheet and
cell for the correct employee. (each employee has a different number)

What I want is to change using a number to using a name eg
=IF('Settlement Sheet'!D9=deb,'Settlement Sheet'!B9,0)