Lookup 2 cell headers one one sheet to find answer on another [Closed]

Report
-
Posts
1915
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 13, 2021
-
Hello,

I am trying to lookup the employee name and week # included on sheet A on sheet B in order to find the % of utilization during that week. The employee name is included in column A on sheet B and the week# is in Column B on sheet A and a header across 6 columns in sheet B. Here is an example.
How do I get the result that in Week 6, J Smith's percentage was 55%?

Spreadsheet A
A B C
1 Name Week # Total Hours
2 J Smith Week 5 25 Hrs
3 J Smith Week 6 22 Hrs
4 J Smith Week 7 15 Hrs

Sheet B
A B C D
Name Week 5 Week 6 Week 7
1 J Smith 10% 55% 42%


config>Windows / Chrome 53.0.2785.116</config>

1 reply

Posts
1915
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 13, 2021
142
jen, good morning.

I'm not sure if I got the idea.

I did a little example for you:
https://www.filedropper.com/

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!