Which formula to use

Ramon Haagen
Occasional Contributor



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 hours it takes to produce something.


The time it takes to produce something is bases on collum E, F and I from tab Test. The tab Base routings should work as a database for collums E, F and I. So depending on which machine is entered and material you get a (plan hours) based on collum C from the tab base items.

I hope I explained it well enough



7 Replies
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?




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

what is the output column? 


now I get it. thankyou.

Perfect thanks!
Related Conversations
formula for data calculation
aayushman_mishra in Excel on
10 Replies
Creating A Sublist
zjohnson in Excel on
5 Replies
Excel Forumla to exclude empty cells.
ulken2019 in Excel on
6 Replies
Need FORMULA help please!!
marislav in Excel on
4 Replies