Alright, so I need data in column A(Last names) and data in column B(First name) to match their respective names on another sheet. When a match is made, it will return column C(Hours worked).
I originally used Vlookup to match last names, something akin to =VLOOKUP(A:A,Week1!A:P,4,FALSE)
But this does not account for employees that may have the same last names. Is there a way to combine two vlookup's? Or is Index a possible solution?
Thank you.
We need to see the workbook, please.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Book2.xlsx
Here is a snap-shot. Sheet2 must search column A and B from sheet1 to match First and Last names. Then the value returned is column C.
Add a helper column in column C of sheet 1 that concatenates A2 and B2 (=A2&B2) and drag down. Now add this into C2 of sheet 2 and drag down:
=VLOOKUP((A3&B3),SHEET1!C2:D7,2,FALSE)
The attached should do the trick
6.xlsx
Hi
If Names in sheet1 is unique (example if Allen Jacob is only) then you can use sumifs function
=SUMIFS(SHEET1!C:C,SHEET1!A:A,A3,SHEET1!B:B,B3)
Formula below will bring first met criteria
=IFERROR(INDEX(SHEET1!C:C,MATCH(SHEET2!A3&SHEET2!B3,SHEET1!A:A&SHEET1!B:B,0)),"") Ctrl+Shift+Enter
Instead of second formula you can use the formula above. Its just an alternative
Appreciate the help? CLICK *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks