Conditional VLOOKUP formula for certain 'conditions' ???

Good morning guys
This time i come with a question which i think you can solve fairly simply, but i have no idea how to pull it off, which is as follows...:


IMAGE 1
1.png


IMAGE 2
2.png

Image 1 shows part of an Operation table in which the hours of machine work are taken into account to keep track of the costs associated to a certain Operation Number, and Image 2 shows part of the price (per hour) table for those machines.

So currently for calculating the total cost of Type 2 Operations i use the following formula:

Please Login or Register  to view this content.

This will only get me the price info from the "below 8 hours" portion. Now what i wish to know (if it is possible , which i think it is) is, what formula should i use if for a certain Operation Number (which will be a Type 2 Operation), a certain machine works more than 8 hours (as shown in lines 3 and 4, or 5 and 6 of example image 1), i want the formula to automatically look up the price from column D of Example image 2 instead of column C.

Now, how is that formula done, can someone enlighten me ?

I wonder if making it an if then stmt would work. So for example, =if(Sheet1!D4>7:59:59;VLOOKUP(Sheet1!D4;Sheet2!$A$1:$D$15;4;0)*E4/0,041666667);VLOOKUP(Sheet1!D4;Sheet2!$A$1:$D$15;3;0)*E4/0,041666667)) (untested)

Thanks for posting a sample, now that I see it, try this formula... =IF(E2<8,VLOOKUP(D2,Sheet2!$A$1:$D$15,3,0)*E2/0.041666667,VLOOKUP(D2,Sheet2!$A$1:$D$15,4,0)*E2/0.041666667)