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

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).

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

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

"cdkjpm" wrote in message
...
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).