Are you required to use lookups in the the formula?

"Mr Wiffy" wrote in message
...
I am having a problem with one of my spreadsheets for my GNVQ I.T.
coursework. Please help!

My spreadsheet is for a boat hire company. On one table is a list of the
boats, times to hire the boats and the cost to hire the boat for that
amount of time.
eg.
Boat One | 2 hours | £25 (per head)
Boat One | 3 hours | £35 (per head)
Boat Two | 2 hours | £30 (per head) etc. etc.

On another sheet, there is a table that lists the customers that have
hired the boats, which boat they hired, how many people are on the boat
and the time it has been hired for.
eg.
Mr R Brown | Boat One | 3 hours | 4 people | (Price) etc. etc.
I want to establish a VLOOKUP in a 'Price' box on the second sheet that
will look for the combination of 'Boat One' and '3 hours' on the FIRST
sheet, then see what the price is and multiply it by how many people are
on the boat.

I tried:
=VLOOKUP(B15:C15 [the cells that Boat One and 3 hours were in on the
second sheet], 'First Sheet'!A10:C40 [the first three columns on the first
sheet, that displayed the boat name, time and price], 3 [which would give
the price as it was in the third column], FALSE)*D4

But this did not work. I think it is something to do with the B15:C15 at
the start of the formula, as when I took one out and left it as B15 the
formula worked fine but obviously did not return the desired result.

I am desperate for some help here and would be grateful for ANY pointers
you could give me!

Thanks in advance,
Imogen