Hi,
Here is the formula:
Just enter it in Q4, copy across and down.![]()
='FTE Calculator'!$O4*INDEX('DATA Sheet'!$R$27:$Z$37,MATCH('FTE Calculator'!$N4,'DATA Sheet'!$Q$27:$Q$37,0),MATCH('FTE Calculator'!Q$3,'DATA Sheet'!$R$26:$Z$26,0))
Cheers![]()
Hi,
Here is the formula:
Just enter it in Q4, copy across and down.![]()
='FTE Calculator'!$O4*INDEX('DATA Sheet'!$R$27:$Z$37,MATCH('FTE Calculator'!$N4,'DATA Sheet'!$Q$27:$Q$37,0),MATCH('FTE Calculator'!Q$3,'DATA Sheet'!$R$26:$Z$26,0))
Cheers![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks