Forum Discussion
Help with pulling formulas from one tab to another
Hi, Can I please get some direction? I have two tabs in Excel. Tab 1 is a Data tab with five columns, A thru E. The 5th column E has a Staff Name drop-down for each cell. Co...
=INDEX('Dropdown staff %'!$B$2:$D$9,MATCH(Data!$E2,'Dropdown staff %'!$A$2:$A$9,0),MATCH(A$1,'Dropdown staff %'!$B$1:$D$1,0))*$D2Maybe with this formula which seems to work in the attached file.
Quadruple_Pawn,
Thank you very much for your help!
Thank you very much for your help!