how do you determine the leave ?
means do you enter "A" for absent or some other text?
Hi, I need to see if a particular person has taken leave on any given day. I am attaching a file which is abridged to make it small. The actual file is much larger and hence needs a formula/function. Please help.
Last edited by AAE; September 6th, 2010 at 21:59. Reason: revise thread title
The Name list is validated so cannot return an #N/A from the row MATCH, but someone could select a date outside the range of your table, so if the column MATCH is #N/A then inform that it is an Invalid Date. To avoid doing the column MATCH twice. Change the main formula to:
Then A23 would contain:
A23 can be anywhere on your worksheet.
Welcome to Ozgrid.
Thread titles are important for obtaining good search results and should be written with this thought in mind -- that is, the title should be search friendly, meaning a search using YOUR title as the search terms will yield good results. Thread titles should concisely and accurately describe the thread contents or objective.
Your thread title of "Please help solve this excel lookup problem" does not adequately describe your thread and is of little help to those searching the forum for solutions to a similar need. As an example for future threads, note the change in your title, which is based on your thread objective and is more specific relative to your need.
Please do not quote entire posts. Quote only if it is needed to provide clarity and context for your reply and only quote the specific part of the post that is relevant.
This will keep the thread clean and uncluttered, making it easier to read.
There are currently 1 users browsing this thread. (0 members and 1 guests)