Dear Experts,
I have a file with 2 sheets, Sheet 1 contains a table with headers as Employee & the Service name against which they will work progressively. Sheet 2 contains a list of all Employees in Col A who may have worked and their hours in Col B & Col C, for billable & non- billable categories respectively. Then i have Col D where i would like the relative service name to appear based on Sheet 1 input. Please note that the Employee's name may appear multiple times in Col A on Sheet 1.
Please take time to see the attached sheet & guide me. I need a formula and may not want to use Validation list.
Thanks,
Mahesh
Bookmarks