Help with Formuls that grab info off another sheet with in same workbook

[bdouglas1011]

Several Questions
1. Under the email body tab I wanted auto populate the cell for daily cost. I do have it automatically get the total cost from the field invoice but how do I write a formula that will automatically enter the right daily cost for which ever day it is.... the start day was the 10/6 then as you follow the sheet down it changes each day. When you enter a (1) under that days column it adds that cost to the bottom for that day. I would like the email body to pull in the daily cost from that column for that particular day if possible.
2. Under the tool list it automatically populates the (used / N/U) & (Days Used) based on if they are checked on the Utilization tab – My question is.... can you get the Date in & Date out to populate based on what days it is used on the Utilization Tab.

[windy58]

Could you use this?

=HLOOKUP(C3,'Field Invoice'!$G$8:$CR$43,35,FALSE)

You may need to adjust to suit

Windy

[bdouglas1011]

How do I adjust it? Can you try it out on the attachment protection password is financial1

[bdouglas1011]

Actually it worked good...how would I do it on the tool list for the Dates in & Dates out

[windy58]

Having big problems putting formulas in on your sheet for some reason.

Could you try this in end date column...
=if($K11="","",$K11+$N11)

Windy

[bdouglas1011]

it works as long as you manually enter in the date in....can you get it auto populate the date in from when you check the box on the utilization sheet.
when you put a "1" in the utilization sheet showing you used it on that day can it save that date on the tool list under the date in column then the formula for date out would work fine.