• 543K Members
• 3,493 Online
• 647K Conversations
SOLVED

## Which formula to use

Highlighted
Occasional Contributor

# 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 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
Highlighted

# RE: Which formula to use

please clear the output you want in your uploaded files. just do it manually. we will figure it out. :)
Highlighted

# Re: RE: Which formula to use

Okay I have entered it manually. Like this?

Highlighted
Solution

# Re: RE: Which formula to use

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`
Highlighted

# Re: RE: Which formula to use

what is the output column?

Highlighted

G

Highlighted

# Re: RE: Which formula to use

now I get it. thankyou.

Highlighted

# Re: RE: Which formula to use

Perfect thanks!
Related Conversations
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
Leap year formula
Hattsoff in Excel on
4 Replies
FORMULAS
aayushman_mishra in Excel on
4 Replies