I have a question on how to setup a spreadsheet that will do a lookup for employees from another spreadsheet. Once it finds them I need to see how many times the have been "early outed" from the center and have an if statement to let me know if it is more than 20% of their schedule. Any reply is a good reply
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
vlookup for list of employee
- Thread starter Spockster
- Start date
Yogi Anand
MrExcel MVP
- Joined
- Mar 12, 2002
- Messages
- 11,454
Hi Spockster:
I have not fully understood your question -- so more detail -- with some sample data, and what exactly are you trying to to accomplish will help. In the mean time, I ought to mention that the us of LOOKUP/VLOOKUP will return a single value ... so if you expect a set of values to be returned at one time, perhaps use of AutoFilter/AdvancedFilter or use of Database Functions may be in order.
Regards!
Yogi
Upvote
0
not sure how to attach a file. but here is a sample.
Spreadsheet 1 has:
Employee Name:
schedule: Date Hours
9/7/02 7:30
9/8/02 7:30
Total: 15:00
This report has the same for all 600 employees.
Spreadsheet 2
Employee Name:
Early Out: Date Hours
9/7/02 2:30
9/8/02 1:30
Total: 4:00
The third Spreadsheet should get the Early outs for each person and display the total for the week and divide into scheduled to see if that person is above 20% of their sceduled hours.
Does that help? I need to get the info from 2 different sheets.
Spreadsheet 1 has:
Employee Name:
schedule: Date Hours
9/7/02 7:30
9/8/02 7:30
Total: 15:00
This report has the same for all 600 employees.
Spreadsheet 2
Employee Name:
Early Out: Date Hours
9/7/02 2:30
9/8/02 1:30
Total: 4:00
The third Spreadsheet should get the Early outs for each person and display the total for the week and divide into scheduled to see if that person is above 20% of their sceduled hours.
Does that help? I need to get the info from 2 different sheets.
Upvote
0
Yogi Anand
MrExcel MVP
- Joined
- Mar 12, 2002
- Messages
- 11,454
Hi Spockster:
It is hard to provide a simulation for data in three sheets, but I hope the following simulation will hwlp in getting started to layout your spreadsheet. There are many factors to consider in laying out the spreadsheet ... the simulation is just to trigger your thinking of the possibilities.</Script></HEAD><BODY BGCOLOR=#E0F4EA><CENTER><FONT COLOR=#339966 SIZE=5>[HtmlMaker 2.20]</FONT></CENTER><HR><SPAN id='ForSubmit'>
</SPAN>
Please post back if you have furthe questions. I am off to bed now, so happy exceling!
Regards!
Yogi
It is hard to provide a simulation for data in three sheets, but I hope the following simulation will hwlp in getting started to layout your spreadsheet. There are many factors to consider in laying out the spreadsheet ... the simulation is just to trigger your thinking of the possibilities.</Script></HEAD><BODY BGCOLOR=#E0F4EA><CENTER><FONT COLOR=#339966 SIZE=5>[HtmlMaker 2.20]</FONT></CENTER><HR><SPAN id='ForSubmit'>
| Book2 | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | |||
| 1 | ||||||||||||||
| 2 | ||||||||||||||
| 3 | ||||||||||||||
| 4 | EmpName | SchedDate | SchedHours | EmpName | OutDate | OutHours | EmpName | SumSchedHours | SumOutHours | Above20Percent | ||||
| 5 | JoeSmith | 9/7/02 | 7:30 | JoeSmith | 9/7/02 | 2:30 | JoeSmith | 15:00 | 4:00 | Yes | ||||
| 6 | JoeSmith | 9/8/02 | 7:30 | JoeSmith | 9/8/02 | 1:30 | ||||||||
| 7 | ||||||||||||||
| 8 | Sheet1 | |||||||||||||
| 9 | Sheet2 | |||||||||||||
| 10 | Sheet3 | |||||||||||||
| 11 | ||||||||||||||
Sheet1 | ||||||||||||||
Please post back if you have furthe questions. I am off to bed now, so happy exceling!
Regards!
Yogi
Upvote
0
Yogi Anand
MrExcel MVP
- Joined
- Mar 12, 2002
- Messages
- 11,454
Hi Spockster:
I don't know how you have the sheet laidout (or how you are going to lay it out). Please note in the sample I gave you, I did not have to use the VLOOKUP function.
Whether you need the VLOOKUP function or not will depend on the layout of your worksheet, and how you manipulate the data.
So, let us see how does your worksheet look like, and then let us take it from there.
Regards!
Yogi
I don't know how you have the sheet laidout (or how you are going to lay it out). Please note in the sample I gave you, I did not have to use the VLOOKUP function.
Whether you need the VLOOKUP function or not will depend on the layout of your worksheet, and how you manipulate the data.
So, let us see how does your worksheet look like, and then let us take it from there.
Regards!
Yogi
Upvote
0
Similar threads
- Question
- Question
