Extracting parent email/phone from a list students

[andreascostas]

I have a list of some 800 students; every day some are absent. I am required to notify
Parents that their child was absent on that day. Every day a get a different list of students who are absent.
It takes me a long time to go from the list of kids

That were absent to the master list of all students and their contact info. Is there a fast way for me

To get the contact info for all absent kids on that day?

Column A has the student’s names (800 -900 names); Column B is the student’s grade; Column C is the guardians email;

Column D is the guardian’s phone number.

Right next to that I paste all the absent kids for that day. Column E is the names of students; Column F is the student’s grade.

Is there a way to have the parent email and parent phone show up in columns H and I?



That way I don’t have to search one student at a time

Thank you in advance

 

[pholt33]

Assuming row 1 are headers and data begins in row 2...

Parent email: =VLOOKUP(E2,A:D,3,false)
Parent phone: =VLOOKUP(E2,A:D,4,false)

Then copy those down to the end of the list of absent students.

 

[andreascostas]

awesome, thank you

 

[rjmdc]

Power query would be even faster
full information
absent list with names and phone numbers
everyday refresh and the info is refreshed