I am trying to use a vlookup or sum to match the first two columns and put the correct wages in the other two columns on the Master List. I am not sure what function I am suppose to use since I don't want it to sum other just the one with the correct names
Last edited by Jerseynjphillypa; 11-21-2011 at 03:22 PM.
Possibly?
=SUMIFS(Main!C$2:C$5,Main!$A$2:$A$5,$A2,Main!$B$2:$B$5,$B2)
copied down and to next column.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
That's perfect...what if a cell is merged together. How can I use sumifs... or is it better to unmerge the cells
always better to unmerge cells... they will cause headaches...
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Thanks for advice and help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks