Hi!
I have two excel sheets, the first sheet has a Family ID column, as does sheet 2. Sheet 2 has the Family ID along with the balance. I would like to move the balance to sheet one, but it has to be in column I and reference the family ID.
For example:
Sheet 1:
Student last name | student first name | student ID number | lunch ID | Family Name | Family ID | School ID | Grade | Lunch Balance
Anderson Jim 10105232 3233 Anderson 8344 020 09
Sheet 2
Family ID | Family Name | Balance
8344 Anderson $33.23
Also I need to change the lunch ID to the last four numbers of the student ID...for example Jim Anderson's lunch ID number needs to be 5232
Thank you so much!!
Bookmarks