I would use the VLOOKUP function in the to-be-filled-in-cells.

Basically you need two columns. One with the DV list and one with the Cost of
Booking.

See Debra Dalgleish's site for info.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben Excel MVP



On Sun, 21 Aug 2005 12:28:01 -0700, Bugaglugs
wrote:

I'm trying to write a formula which will generate a value in one cell
dependent on what the user chooses in the other. See below for example (the
worksheet is to record the charges incurred when certain rooms within a
complex are booked).
So for example if the 'blue room' is booked, the the corresponding cell in
row 2 should be prefilled with '£2500'
(Row 1) (Row 2)
Room Booked Cost of Booking
(Choices - I've used data validation)
Blue Room
Red Room
Blue Room & Red Room
Green Lounge
Whole Complex