Cell Value Depends on Other Cell Value
 

Hi,
I created a worksheet that contains a list cell (from Data - Validation -
List (List Name = City))
The list is on another worksheet (named Data) and is called City (range
A2:A27) that contains city names
On the same worksheet, I have another list called Miles (range B2:B27) that
contains the mileage from my town to the towns listed in City.
How can I display the mileage depending on what city is selected in the list
cell?
Thanks,
John

Cell Value Depends on Other Cell Value
 

You can use Vlookup John
with in a1 the data validation cell

=VLOOKUP(A1,Sheet2!A2:B27,2)

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Grease" wrote in message ...
Hi,
I created a worksheet that contains a list cell (from Data - Validation -
List (List Name = City))
The list is on another worksheet (named Data) and is called City (range
A2:A27) that contains city names
On the same worksheet, I have another list called Miles (range B2:B27) that
contains the mileage from my town to the towns listed in City.
How can I display the mileage depending on what city is selected in the list
cell?
Thanks,
John