| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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). |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| link worksheet A & B | Excel Worksheet Functions | |||
| Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
| advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
| in excel I want to set up a drop down & link that to another cell | Excel Worksheet Functions | |||
| link drop down menu to info in worksheet | New Users to Excel | |||
Linear Mode
