Vlookup or Index Match Function?
Hello,
I couldn't exact hours, if i select same project number twice and put hours in front of it.
I have used Vlookup function, but shows inappropriate result if data duplicated. I am preparing employee time sheet for whole year.
I have attached sample sheet of it
Maybe you need..
=SUMIF('User-1'!C:C,C5,'User-1'!AL:AL)
Life's a spreadsheet, Excel!
Say thanks, Click *
Thank you very much Ace_XL for your help
I would also consider the Indirect formula...
Time saver... though you will need to rename the headers in row 3 like D3 needs to become User-1 instead of User1 (Should match the tab name)
Please Login or Register to view this content.
Cheers -
-If you think you are done, Start over - ELeGault
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks