Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data Validation
I have set a drop-down list up and would like a single selection to populate
several cells in a row from a table I have set up. Specifically the drop-down list would offer short form product names. Once selected the choice would fill in the long description and list price from the second worksheet table I set up. This is a quote automating tool I am developing. Thanks in advance. |
#2
|
|||
|
|||
One way:
Assuming your table is named Table with the description in column 2 and the price in column 3 of the table, and your dropdown is in column A: B1: =IF(A1<"",VLOOKUP(A1,Table,2,FALSE) C1: =IF(A1<"",VLOOKUP(A1,Table,3,FALSE) In article , "Tony" wrote: I have set a drop-down list up and would like a single selection to populate several cells in a row from a table I have set up. Specifically the drop-down list would offer short form product names. Once selected the choice would fill in the long description and list price from the second worksheet table I set up. This is a quote automating tool I am developing. Thanks in advance. |
#3
|
|||
|
|||
Thanks for the response. I can't wait to try it.
Tony "Tony" wrote: I have set a drop-down list up and would like a single selection to populate several cells in a row from a table I have set up. Specifically the drop-down list would offer short form product names. Once selected the choice would fill in the long description and list price from the second worksheet table I set up. This is a quote automating tool I am developing. Thanks in advance. |
#4
|
|||
|
|||
I tried it and it didn't work. My table is on a second worksheet named
"Lifts" and has the drop-down values in Column A, long description Col B and the price in Col C. I created a new column for the drop down in my application and I can choose my selection. But it doesn't fill in the other columns. Help if you can. Tony "JE McGimpsey" wrote: One way: Assuming your table is named Table with the description in column 2 and the price in column 3 of the table, and your dropdown is in column A: B1: =IF(A1<"",VLOOKUP(A1,Table,2,FALSE) C1: =IF(A1<"",VLOOKUP(A1,Table,3,FALSE) In article , "Tony" wrote: I have set a drop-down list up and would like a single selection to populate several cells in a row from a table I have set up. Specifically the drop-down list would offer short form product names. Once selected the choice would fill in the long description and list price from the second worksheet table I set up. This is a quote automating tool I am developing. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Data Validation Window? | Excel Discussion (Misc queries) | |||
Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
data validation on sth else | Excel Worksheet Functions |