Help I need an excel expert!

Ms-Pacman

I am trying to get a spreadsheet for a number of teams showing who is working out of each team on an On-Call rota
What I have created is a front page tab with a list of team names with the =TODAY() and =NOW() at the top with separate tabs for each team with each row showing date/time start and date/time finish with the staff name and tel entered fr that shift

What I am trying to do is to get the front sheet listing each team name to look at a relevant tab and see who is working for that date and pull the name and telephone number across using:

=IF(ISNA(VLOOKUP($B$5,Team1!$B$8:$M$112,8,FALSE)),"Not Found",VLOOKUP($B$5,Team1!$B$8:$M$112,8,FALSE))

I’ve got the above working but the information is wrong after 12.01am as each on call member works from 9am to 9am the following day, so looking at just the date doesn’t do what I need it to do.

I have on each teams tab a separate column for the: Date shift starts, time shift starts, date shift ends and time shift ends
Is there a way for the formula to see that if the date and time is after x but before y then enter the name and telephone number from that line.

I'm a bit of a novice and am getting nowhere fast.
Sorry if this is as clear as mud!
All help much appreciated

TrickyDicky101

Hi

I am finding it difficult to fully understand how your data is organised. If you could provide a sample of the data (cleansed to remove any confidential information) then i can help. Make sure you explain as clearly as possible, given the sample, what it is you want to do and what the expected result would be. I will send you a PM with my email address.

Alternatively, I would advise posting your question here:

www.mrexcel.com/forum

you would need to sign up for an account (but that is free) and then there are thousands of clever people who could help.

Ms-Pacman

thanks, have sent you mail.
I have also posted it on the MrExcel forum but am getting a bit confused with their reply so just trying to figure it out!