Questions

How to use "DaysLookUp" function in Excel 2003.

+
0 Votes
Locked

How to use "DaysLookUp" function in Excel 2003.

Richied
Dear Everyone,

Can anyone advise me how to use the "DaysLookUp" function in Excel 2003.

I have a document, not created by me.

On the summary page there is a list of names in the A column and the months of the year appear horizontally in the second row.

Each person has a separate worksheet which has the person's name as the title.
In the main body of the document there is the following formula: "=DaysLookup("AL",E$2,$A8)".

Where "AL" represents "Annual Leave", "$A8" represents name of the person and "E$2" represents the month.

This function works fine for existing worksheets; however, if I create a new worksheet on a new person, or change the title of an existing worksheet for the new person, then a problem arises with the formula. Instead of displaying the number of days of Annual Leave, the cell displays the following: "#######". In the cell which has a simple mathematical formula ("Total Annual Leave Allowance" minus "Annual Leave Taken") I get the following: "#NAME?".

There is another way to achieve the same result, which is by using a formula of the type: "='Worksheet title'!B$37".

However, I would be very grateful if anybody could advise how to use the "DaysLookUp" function. Also, I wonder whether there is any advantage to using the "DaysLookUp" function.

Please advise.

Thank you very much.

Kind regards.

Rich.