How to link a drop down value to a cell in a different worksheet?

G

Guest

I have two Excel sheets in the same Workbook. Sheet 1 has a description in
one column and the listing price in another column. I need to know how to
link those two columns together so when I create my drop down list in Sheet 2
it will automatically bring over the Price from sheet 1 to sheet 2.
(Worksheet 2 has a dropdown list of all of my items from sheet 1).
 
B

Biff

Hi!

Try this:

Drop down list on Sheet2 cell A1.

Description and price on Sheet1 in the range A1:B100.

Formula for Sheet2 cell B1:

=VLOOKUP(A1,Sheet1!A1:B100,2,0)

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dependent drop down dynamic range formula, off sheet. 7
Copy corresponding cell in Column B if cell in A contains certain text? 1
Using drop-down lists 4
Formatted cell column in drop down list 1
Drop Down with dynamic named range offsheet source list 14
compare and return a value from another worksheet 3
Automatic Drop Down List 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Top