I am trying to create a leave log in excel. I have a sheet that needs to be
turned into admin as well as 12 months worth of tracking (each month on an
individual sheet.. Jan-Dec.)

I have the workbook set up so that for each day it iwll look through all of
the sheets and give me the status of the personnel. Or rather, how many
people are present or missing for that day.

What I need now, for a function to look for today's date, locate who is on
leave(Marked by an LV in the corresponding cell next to their name), and
return the person's name in the cell.

I have been trying to use combinations of IF, HLOOKUP, and VLOOKUP
functions. So far I have only gotten a #VALUE error or an #NA error.

I would really appreciate any help you can give me.

What I need now, for a function to look for today's date, locate who is on
leave(Marked by an LV in the corresponding cell next to their name), and
return the person's name in the cell.

Where is today's date? Where are the names? Where is "LV"?

In other words, DETAILS, DETAILS, DETAILS!

Biff

"CiceroCF" wrote in message
...
I am trying to create a leave log in excel. I have a sheet that needs to
be
turned into admin as well as 12 months worth of tracking (each month on an
individual sheet.. Jan-Dec.)

I have the workbook set up so that for each day it iwll look through all
of
the sheets and give me the status of the personnel. Or rather, how many
people are present or missing for that day.

What I need now, for a function to look for today's date, locate who is on
leave(Marked by an LV in the corresponding cell next to their name), and
return the person's name in the cell.

I have been trying to use combinations of IF, HLOOKUP, and VLOOKUP
functions. So far I have only gotten a #VALUE error or an #NA error.

I would really appreciate any help you can give me.