Multiple criteria formula needed

**BDD2015** · 08-12-2019, 10:35 AM

Haven't spent much time on Excel in a very long time, wasn't really good at formulas to begin with, but right now feel like I am back at Day 1 with no idea...

Looking for a simple formula - Based on a date and employee ID#, need to pull the type of leave they took.

TIA

**Fluff13** · 08-12-2019, 10:41 AM

How about
=INDEX(Raw_Data!$E$2:$E$14,MATCH($A$1&"|"&$B4,INDEX(Raw_Data!$A$2:$A$14&"|"&Raw_Data!$B$2:$B$14,0),0))

**AliGW** · 08-12-2019, 10:43 AM

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No further help to be offered until this moderation request has been fulfilled.)

**BDD2015** · 08-12-2019, 11:54 AM

Perfect. Thank you so much for your help, Fluff13

**BDD2015** · 08-12-2019, 11:55 AM

Perfect. Thank you so much for your help Fluff13

**AliGW** · 08-12-2019, 11:59 AM

You still need to update the thread title, please, so that it is helpful for anyone looking for help with similar issues. Please don't ignore moderation requests.

Administrative Note:

Rule #6 of our Forum RULES:

Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction, then send a private message to them asking for clarification.

**BDD2015** · 08-13-2019, 05:11 AM

Good morning,

Wasn't ignoring... Haven't been online since I left work. Thread title changed. Hope it suffices.

**AliGW** · 08-13-2019, 05:14 AM

Look at the timestamps, please - my request for the title change was posted over an hour before your last visit to this thread yesterday, at which point you failed to act, hence the reminder.

The title is better, but still not very explicit: please try harder to convey your needs in future thread titles. Thank you.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.