Home

Need help writing an Excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-471773%22%20slang%3D%22en-US%22%3ENeed%20help%20writing%20an%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-471773%22%20slang%3D%22en-US%22%3EI%20have%202%20Excel%20Workbooks%20saved.%20Both%20files%20have%20a%20column%20labeled%20Family%20ID%20which%20is%20a%20number%20corresponding%20to%20every%20member%20in%20one%20family.%20Each%20family%20has%20a%20unique%20number.%3CBR%20%2F%3E%3CBR%20%2F%3EFile%20A%20has%20the%20following%20columns%3A%20Family%20ID%20in%20descending%20order%3B%20child%E2%80%99s%20first%20name%3B%20Primary%20Parent%20and%20Spouse%20Name%3B%20and%20Primary%20cell%20phone.%20(Parents%E2%80%99%20last%20names%20are%20often%20not%20the%20same%20as%20the%20child%E2%80%99s%20last%20name.)%3CBR%20%2F%3E%3CBR%20%2F%3EFile%20B%20has%20the%20following%20columns%3A%20Family%20ID%20in%20descending%20order%3B%20child%E2%80%99s%20first%20name%3B%20child%E2%80%99s%20last%20name%3B%20child%E2%80%99s%20birthday%2C%20and%20child%E2%80%99s%20allergies.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20need%20to%20insert%20the%203%20column%E2%80%99s%20information%20(child%E2%80%99s%20last%20name%2C%20birthday%2C%20and%20allergies)%20from%20File%20B%20into%20File%20A.%20However%2C%20there%20are%20many%20additional%20Family%20ID%E2%80%99s%20listed%20in%20File%20B%20that%20are%20not%20listed%20in%20File%20A.%20(I%20only%20need%20the%20info%20for%20the%20children%20listed%20in%20File%20A.)%3CBR%20%2F%3E%3CBR%20%2F%3EI%20will%20need%20to%20do%20this%20calculation%20on%20a%20monthly%20basis%20for%20each%20Sunday%20School%20class.%20File%20A%20is%20created%20using%20a%20child%E2%80%99s%20attendance%20record%20for%20the%20last%206%20weeks%20and%20thus%20will%20be%20different%20every%20month.%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20you%20help%20me%20write%20a%20formula%20to%20search%20for%20each%20needed%20Family%20ID%20listed%20File%20A%2C%20and%20pull%20the%20needed%20column%20information%20for%20each%20child%20from%20file%20B%20into%20new%20columns%20in%20the%20corresponding%20child%E2%80%99s%20row%20in%20File%20A%3F%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20help%20you%20can%20give%20me%20would%20be%20soooooo%20appreciated.%3CBR%20%2F%3E%3CBR%20%2F%3ESusie%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-471773%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EHelp%20writing%20an%20Excel%20Formula%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-477120%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20writing%20an%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-477120%22%20slang%3D%22en-US%22%3EYou%20need%20to%20attach%20your%20sample%20files%20to%20avoid%20plenty%20of%20assumptions.%3C%2FLINGO-BODY%3E
Deleted
Not applicable
I have 2 Excel Workbooks saved. Both files have a column labeled Family ID which is a number corresponding to every member in one family. Each family has a unique number.

File A has the following columns: Family ID in descending order; child’s first name; Primary Parent and Spouse Name; and Primary cell phone. (Parents’ last names are often not the same as the child’s last name.)

File B has the following columns: Family ID in descending order; child’s first name; child’s last name; child’s birthday, and child’s allergies.

I need to insert the 3 column’s information (child’s last name, birthday, and allergies) from File B into File A. However, there are many additional Family ID’s listed in File B that are not listed in File A. (I only need the info for the children listed in File A.)

I will need to do this calculation on a monthly basis for each Sunday School class. File A is created using a child’s attendance record for the last 6 weeks and thus will be different every month.

Can you help me write a formula to search for each needed Family ID listed File A, and pull the needed column information for each child from file B into new columns in the corresponding child’s row in File A?

Any help you can give me would be soooooo appreciated.

Susie
1 Reply
You need to attach your sample files to avoid plenty of assumptions.
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies