Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you solve this????
"I have a distribution list of 5 cities in cell A1, 5 manufacturers in cell
B1, 5 products category in cell C1, and 5 product list in cell D1." Now, I want that if I select one particular city in cell A1, then it should give me options to select manufacturers available in that city only. Again, when I select one particular manufacturer in cell B1, then in cell C1 it just show me product category produced by that particular manufacturer. Then, continuing from previous step I select one product category from that list (cell C1) and then it should give me products list under that category in Cell D1. Now, finally selecting an item from the product list in Cell D1, it should pop up the username in Cell E1. Now, as far as this username is concerned I know their combination...... So, what I want is that.... when particular city, manufacturer, category and product is selected it gives me username in cell E1. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you solve this????
If anyone has a suggestion, which post should they reply to.
I'm sure you wouldn't want any potential poster to waste their time if the question has already been answered. mahendra2210 wrote: "I have a distribution list of 5 cities in cell A1, 5 manufacturers in cell B1, 5 products category in cell C1, and 5 product list in cell D1." Now, I want that if I select one particular city in cell A1, then it should give me options to select manufacturers available in that city only. Again, when I select one particular manufacturer in cell B1, then in cell C1 it just show me product category produced by that particular manufacturer. Then, continuing from previous step I select one product category from that list (cell C1) and then it should give me products list under that category in Cell D1. Now, finally selecting an item from the product list in Cell D1, it should pop up the username in Cell E1. Now, as far as this username is concerned I know their combination...... So, what I want is that.... when particular city, manufacturer, category and product is selected it gives me username in cell E1. -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you solve this????
Hi,
You want to create dependent lists. Kindly refer to the following link http://www.contextures.com/xlDataVal02.html -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "mahendra2210" wrote in message ... "I have a distribution list of 5 cities in cell A1, 5 manufacturers in cell B1, 5 products category in cell C1, and 5 product list in cell D1." Now, I want that if I select one particular city in cell A1, then it should give me options to select manufacturers available in that city only. Again, when I select one particular manufacturer in cell B1, then in cell C1 it just show me product category produced by that particular manufacturer. Then, continuing from previous step I select one product category from that list (cell C1) and then it should give me products list under that category in Cell D1. Now, finally selecting an item from the product list in Cell D1, it should pop up the username in Cell E1. Now, as far as this username is concerned I know their combination...... So, what I want is that.... when particular city, manufacturer, category and product is selected it gives me username in cell E1. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if A1<0 let B2 =A1 and if A1=0 let B3=A1 solve PLEASE!!!!!!!!!! | Excel Worksheet Functions | |||
Can you help me solve! | Excel Discussion (Misc queries) | |||
Let's see if you can solve this. | Charts and Charting in Excel | |||
How do I solve for x? | Excel Worksheet Functions | |||
need help to solve this | Excel Discussion (Misc queries) |