Forum Discussion
Solved
Which formula to use
Hello, I have been trying to figure out this one for a few hours and I cannot find the solution myself. What I would like to have in my file is that in collum G(plan hours) is shown how much hour...
Ramon,
my guess would be:
=F2*LOOKUP(PI(),1/('Base routings'!$B$3:$B$332=E2)/('Base routings'!$A$3:$A$332=I2),'Base routings'!$C$3:$C$332)/60/60
please clear the output you want in your uploaded files. just do it manually. we will figure it out. :)
Okay I have entered it manually. Like this?
what is the output column?
now I get it. thankyou.
Ramon,
my guess would be:
=F2*LOOKUP(PI(),1/('Base routings'!$B$3:$B$332=E2)/('Base routings'!$A$3:$A$332=I2),'Base routings'!$C$3:$C$332)/60/60- Perfect thanks!