Need to lookup multiple text by date

**nmckever** · 07-28-2012, 05:27 PM

Hello all,

I am new to creating spreadsheets in excel and I am having difficulty finding a formula that will look up the employee name and leave request in the 'LeaveData' tab and match it with the date that has been selected from the drop down list on the 'Staff Leave Database' tab. The goal is that whenever the drop down date is selected it will auto populated the information relevant to that day. I tried using index and match formulas and have also tried using the vlookup function like I did in the 'LeaveData' tab, but I am stuck and cannot figure it out.

Attachment 170929

Thanks

**dilipandey** · 07-29-2012, 01:36 AM

Hi nmckever,

See the attached file where I have used following array formula to achieved the desired results:-

Formula:

Please Login or Register  to view this content.

Leave_Planner_v6.xlsm

Regards,
DILIPandey

<click on below 'star' if this helps>

**nmckever** · 07-29-2012, 03:20 PM

Thank you for your assistance, this really helped a lot!

**dilipandey** · 07-30-2012, 12:40 AM

You are welcome nmckever...!!

Cheers

Suggest you to mark this thread as [SOLVED].... thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**Cutter** · 07-30-2012, 08:08 AM

@ nmckever

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

**nmckever** · 07-30-2012, 08:44 AM

I am still having some challenges with the spreadsheet. I forgot to include pulling data for a range of dates. Right now it only allows me to get the data per day. Is there any way I can let it pull data per week and per month? I am so lost!!!