Forum Discussion
Referencing sheets based on a drop-down option
Hi there guys! Hopefully this question isn't super complicated, but I am trying to make things simple for my co-workers. We're making a project hours tracker using excel since our team is too small t...
Let's say the drop-down with employee names is in B1 on the supervisor sheet.
Change the formula
=SUMIF('Employee Name'!A:A,'Hours Report'!A3,'Employee Name'!D:D)to
=SUMIF(INDIRECT("'"&$B$1&"'!A:A"), A3, INDIRECT("'"&$B$1&"'!D:D"))
