I have a data base which is sheet 1 and an extract which is sheet 2. I want to take the total from the sheet 2 and have it to be populated into my total in sheet 1 with the matching criterias. How would I get the corresponding total from sheet 2?


Sheet 1
Serial # Name Total
123456 Thomas
7890 Joespeh

Sheet 2
Serial # Name Total
123456 Thomas 55
7890 Joeseph 40

Thanks