Help With Formula Please

[Get_Involved]

I am trying to combine this formula

=IFERROR(1/1*(IF(D32=1,'Hours Of Service'!E4,IF(D32=2,'Hours Of Service'!N4,"")*1)),"")

With this Formula

=INDEX(E11:E18454,MATCH(TRUE,(D10:D18454>='Pre Trip Bid Summary'!I24),0))*60

This is one of the several ways I have tried.
I have gotten two different answers, (1, and 60), the answer should be 720

=IFERROR(1/1,IF(D32=1,INDEX('Hours Of Service'!E11:E18454,MATCH(TRUE,('Hours Of Service'!D10:D18454>=I24),0))))

I know what cell to put it in, I just can't rework the formula the correctly.

Any help will be appreciated, Thank You.

 

[KolGuyXcel]

Try

=IFERROR(IF(D32=1,INDEX('Hours Of Service'!E11:E18454,MATCH(TRUE,('Hours Of Service'!D10:D18454>=I24),0))),1/1)

But I'm not sure what values are in the cells 'Pre Trip Bid Summary'!I24, 'Hours Of Service'!E11:E18454 and 'Hours Of Service'!D10:D18454.

 

[Get_Involved]

Thank You KolGuyXcel:

Works like a charm.
What my problem was The one you weren't sure about, was the single formula that worked with two cells doing the work.

in my workbook I have 7 separate loads, that I had to build 7 separate Hours Of Service tabs so that each load had its own Hours Of Service with different names Hours Of Service Load 1, Load 2, Ect.

Now I can do all 7 loads with 1 Hours Of Service Tab, this will make the workbook much faster.

I can't believe I explained the project right the first time.

Thank You Bunches.