| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using a name in an excel formula in a workbook
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) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel exits unexpectedly or hangs the second time I open workbook | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| In excel the formula bar behaves differently on different machines | Excel Discussion (Misc queries) | |||
| can i make a formula to search keywords in a excel workbook? | Excel Worksheet Functions | |||
| Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
