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
Highlighted
You need to attach your sample files to avoid plenty of assumptions.
Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies