Moving data from Sheet 2 to Sheet 1

[jmeddaugh]

Hello!!
Here is the fields I have in sheet 1:
Student Last name | Student First Name | Student ID Number | Lunch ID | Family Name | Family ID | School ID | Grade | Lunch Balance

and example of data in those fields:
Anderson | John | 10105543 | 5543 | Anderson | 3994 | 120 | 11 | $0.00

Sheet 2:
Family ID | Family Name | Balance

Example data of sheet two data:
3394 | Anderson | $32.22

What I need to do is transfer the balance (example: $32.22) from sheet 2 to sheet 1. The only reference is the Family ID. So is there a way to move the data to sheet one by saying if Family id is 3394 then transfer balance from sheet 2....or something like that??

Thank you in advance!!!

 

[bsmill2]

Hello!!
Here is the fields I have in sheet 1:
Student Last name | Student First Name | Student ID Number | Lunch ID | Family Name | Family ID | School ID | Grade | Lunch Balance

and example of data in those fields:
Anderson | John | 10105543 | 5543 | Anderson | 3994 | 120 | 11 | $0.00

Sheet 2:
Family ID | Family Name | Balance

Example data of sheet two data:
3394 | Anderson | $32.22

What I need to do is transfer the balance (example: $32.22) from sheet 2 to sheet 1. The only reference is the Family ID. So is there a way to move the data to sheet one by saying if Family id is 3394 then transfer balance from sheet 2....or something like that??

Thank you in advance!!!

Provided allcells are correctly located Put equation into first Student Balance by clickinginto that box then copy and paste equation (at bottom) into the Function (fx)window at top of sheet. Then click on checkmark at function window. It shouldbring that student’s Balance over from Sheet (2) to Sheet (1).<o></o>
Againproviding the col. & Rows are the same as above. Sheet (1) = Last Name “Anderson”in Cell (“A2”) and continuing to his Bal. In Cell (“I2”) and Sheet (2) as FamilyID “3994” = Cell (“A2”) to Bal. “$32.22” Cell (“C2”). If this is correct OnSheet (1) make sure that ALL student grades or something is entered (NO emptyCells in Col. “H”), then go to First Student Balance (“I2”) Click in Cell, thenkeep curser in cell and move to lower right corner of cell and curser willchange to a solid black plus sign “+” then double click. That action shouldcopy the equation to the bottom of the data in that column or last studentbalance bringing all balances over to Sheet (1) from Sheet (2). Check to make sure…If by chance you get a blankCell in the Bal. Col. Sheet (1), Check BOTH sheets for different Fam. ID # andblank cells in Bal Col. of Sheet (2) will result in a zero bal on Sheet (1). <o></o>
<o> </o>
Copy exactlyas it is here. Select Sheet (1) Cell (“I2”) and Paste into Cell or (fx)Function Window. Click checkmark select I2 at + sign lower right corner doubleclick to copy down.<o></o>

=IF($F2=Sheet2!$A2,Sheet2!$C2,"")<o></o>
<o> </o>
Keep thisequation someplace handy in case someone changes something or deletes somethingin Bal. Col. on Sheet (1). If this happens Follow directions above to correct.<o></o>
<o> </o>
Bsmill<o></o>

 

[markmzz]

Maybe this:

=IFERROR(VLOOKUP(F2,Sheet2!$A:$C,3,0),0)

Markmzz

 

[bsmill2]

Markmzz Your function works fine with one exception, Just a IF question; what happens IF John's sister is added to the list of students? same Last name but first name Julia, also same family ID but maybe in row 20 and a different amount for her lunch balance. It is going to give her John's balance, Right? bsmill

 

[markmzz]

Markmzz Your function works fine with one exception, Just a IF question; what happens IF John's sister is added to the list of students? same Last name but first name Julia, also same family ID but maybe in row 20 and a different amount for her lunch balance. It is going to give her John's balance, Right? bsmill

What you want in this case?

Markmzz