I have a list of names that extend from cells D1:Y1. Below that in rows 16-22 are a list of tasks that the person could engage in, and in his relevant row would be a number pertaining to how many hours that task could be.
So essentially, i am hoping to find a formula that will lookup the person's name in row 1, and then sum the numbers in rows 16-22. Is this possible?
Thanks,
Ernie
So essentially, i am hoping to find a formula that will lookup the person's name in row 1, and then sum the numbers in rows 16-22. Is this possible?
Thanks,
Ernie