Formula to Lookup values with multiple criteria

Hi Guys,

I'm looking to build a formula to lookup some values from a table,

i assume i can use INDEX, MATCH but the information i'm pulling up is not coming out accurate.

there is database where i'm pulling up the information from. it's called "database". i'm trying to load the values on a table on"summary" sheet.

but the trick is to have the information pulled up by date. whenever i change the date it loads the information from that specific day. i need this to create a simple database.

The formula i built works just for a few of them.

=INDEX(Database!$A$1:$J$1200,MATCH(C7,Database!$C$1:$C$1200,0)*(Database!$A$1:$A$1200=$C$5),4).

i'm attaching the workbook.

please need some help over here.

thanks a lot guys!

try

Formula:

Please Login or Register  to view this content.

Hi Sandy, i just tried the formula, it works perfectly!!!! thank you very much!!

If the basic problem is solved
- it's always a good practice to show respect to the person(s) who have helped you
- is a click on the Add Reputation first (left lower corner of the post of person(s) who helped you)

Thanks

Thanks for rep

you're welcome! just a final questions.... what happen if i want to return text values. SUMPRODUCT won't do the work. any suggestion?

thanks again!!

thanks for replying back! i guess the answer from Sandy666 worked perfectly. guys i'm still having a questions about how to lookup values with multiple criteria,
i'm attaching the file please see sheet " Daily metrics ". there is column called "Balance" to the left. i'm trying to figure out how to call the current balance from the minutes late but the the specific month i want. whenever a pull up the date i see the balance from that month only. i've tried a lot of formulas. any idea?

Not sure I understand the questions but if you want Balance to be a running total of the Month of the date in N6, use this:

=SUMIFS(Attendance!$E$2:$E$12000,Attendance!$B$2:$B$12000,J12,Attendance!$A$2:$A$12000,">=" &DATE(YEAR($N$6),MONTH($N$6),1), Attendance!$A$2:$A$12000,"<=" &DATE(YEAR($N$6),MONTH($N$6),31) )

Hi Carsto, i've tried that formula and works perfect i wanted to see the sum of minutes late for a month in specific. what i'm looking forward is to have in that column the balance for that specific month. there will be ppl who will recover time so whatever is the real balance i need to see it. if at the end of the month there is nobody owing time as they recovered already the balance should be zero. it's more like to show the blance for the month instead of a sum of all minutes late in a month for a specific member. hope this helps to be understood :S