Hi,

I am using a worksheet to record vehicle usage hours and the cost.

I have a simple worksheet. In the first column there is a drop down list for
the registration numbers of the vehicles. The list this is drawn from is on
the same page as the rest of the worksheet, just completely out of the way.

In the 3rd Column I will be listing the job numbers and then entering the
hours for each job in the 5th column and onwards (5th and on is a columnn per
day, 4th is a total for each job).

What I want the 2nd column to do is, dependant on the reg number selected,
to use the hourly cost (in the same list as the reg numbers) and multiply it
by the hours I am entering.

I have no idea what formula to use or how to get it to notice the right
information. The reg number will not always be the same as some weeks some of
the vehicles aren't used, otherwise I could have just listed all of them and
put in a =SUM(TOTALHOURS*HOURLYCOST). This, however, if all vehicles are not
being used, will not be particularly clear.

Can you help?

Thank you in advance