Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I enter data in an adjacent cell based on a list selection?
I have 2 sheets in this workbook. Sheet 1 (named "part list") has a range
B2:B2000 which I have named "parts". In column C I have another range (C2:C2000) named "description." My question is, after I have the data validation list set up in the cells of column E on sheet 2 (named "R&D log"), how can I make the cell in the same row in column F come up as the description that goes with the selected part? For example: sheet 1 B C PN description 1 1 part 1 2 2 part 2 3 3 part 3 4 4 part 4 sheet 2 E F 20 4 part 4 21 1 part 1 22 3 part 3 I think it has something to do with VLOOKUP, but I can't seem to get it to work right. Please help if you can. THANK YOU! Mike |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I enter data in an adjacent cell based on a list selection?
I think this will do you if i'm looking at this right:
=vlookup(E20,B2:C2000,2,false) -- -John Please rate when your question is answered to help us and others know what is helpful. "WiFiMike2006" wrote: I have 2 sheets in this workbook. Sheet 1 (named "part list") has a range B2:B2000 which I have named "parts". In column C I have another range (C2:C2000) named "description." My question is, after I have the data validation list set up in the cells of column E on sheet 2 (named "R&D log"), how can I make the cell in the same row in column F come up as the description that goes with the selected part? For example: sheet 1 B C PN description 1 1 part 1 2 2 part 2 3 3 part 3 4 4 part 4 sheet 2 E F 20 4 part 4 21 1 part 1 22 3 part 3 I think it has something to do with VLOOKUP, but I can't seem to get it to work right. Please help if you can. THANK YOU! Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Update of Dropdown List Box data | Excel Worksheet Functions | |||
Sumproduct issues | Excel Worksheet Functions | |||
How to Enter data and Function in same cell | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
How to filter and list data based on different data. | Excel Worksheet Functions |