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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies