Extract login and logut data from one worksheet to another

[nmckever]

Hello,

I am trying to create a report that will allow me to extract login and logout data from the Rawdata sheet in excel to my Summary sheet. The concept that I am trying to achieve is to have a summary page that will allow me to select an employee from a dropdown list and once that employee is chosen, their login times will be listed by date. Currently, my summary page auto-populates the date so the only information that needs to be retrieved is the login information based off the employee name and date. I am very new to excel and have tried several different ways to achieve this concept but have been unsuccessful. Any assistance as to what I am doing wrong and/or what formulas would be best to use would be greatly appreciate. Please Help, I have been racking my brain trying to figure this out
index.xlsx

[TMS]

C9: =INDEX(Rawdata!D$3:D$82,MATCH($B9&$C$3,Rawdata!$A$3:$A$82&Rawdata!$B$3:$B$82,0))

committed with Ctrl-Shift-Enter rather than just Enter.

Copy to column D and then down.


Regards, TMS

[nmckever]

Thank so much, this really helped me out!

[TMS]

As you're using Excel 2010, you can "tidy it up" a little with IFERROR:

=IFERROR(INDEX(Rawdata!D$3:D$82,MATCH($B9&$C$3,Rawdata!$A$3:$A$82&Rawdata!$B$3:$B$82,0)),"")

committed with Ctrl-Shift-Enter rather than just Enter.

Copy to column D and then down.


Regards, TMS

[nmckever]

Will the last formula you provided clear up any of the n/a in the fields that don't have any value?

[TMS]

You're welcome. Thanks for the rep.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[TMS]

You might have to check for that separately.

=IF(OR($B9="",$C$3=""),"",IFERROR(INDEX(Rawdata!D$3:D$82,MATCH($B9&$C$3,Rawdata!$A$3:$A$82&Rawdata!$B$3:$B$82,0)),""))

committed with Ctrl-Shift-Enter rather than just Enter.

Copy to column D and then down.


Regards, TMS