Cell referencing and linkages

ahwirengrk

New Member
Joined
Sep 9, 2014
Messages
2
I am trying to link two columns, A and B,such that once an item is selected from a drop down list in column A, the corresponding item will automatically come up in the other column. for e.g Column A for cars and Column B for price of cars. I want to link the two columns so that once i select a type of car from the drop down list in say column A, the list in column B will automatically select the corresponding price of the car in column B. Some advice will be appreciated.
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Watch MrExcel Video

Forum statistics

Threads
1,108,632
Messages
5,523,994
Members
409,554
Latest member
denistrevisan

This Week's Hot Topics

Top