Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Question

Excel Formula Help

by Feb 28, 2014 12:19AM PST

I am a teacher and I have a list that contains EVERY student in my school and their homeroom teacher. I have another list (Truancy List) of students with 10 or more absences but no homeroom teacher. Is there a formula I can use to pull the homeroom teacher for each truant student into my Truancy list? Thanks!

Discussion is locked

3 Posts
- Collapse + Expand Details
- Collapse -
Clarification Request
Did you try vlookup? Video about follows.
by r. proffitt Forum moderator Feb 28, 2014 12:34AM PST
- Collapse -
Answer
Agree with Bob....as long as the student names are spelled
by Feb 28, 2014 9:51AM PST

the same and there are no duplicates, Excel's "vlookup" is a simple tool that could it.

VAPCMD

- Collapse -
Answer
(NT) How did it turn out ???
by Mar 14, 2014 9:30AM PDT
Back to Office & Productivity Software forum

CNET Forums

Operating Systems
Software
Electronics & Gadgets
Hardware
Tablets & Mobile Devices
General Help
Brand Forums
Roadshow Autos
Off Topic

Other Forums

Forum Info