Cell Value Depends on Other Cell Value

  • Thread starter Thread starter Grease
  • Start date Start date
G

Grease

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
 
You can use Vlookup John
with in a1 the data validation cell

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