Need help in making a list file

[ajay20616]

Hi every one....

This is my first post in excelforum....

I want to know, how I can do the following

Column A will consist of different product names
Column B will consist of individual code for each product that is mentioned in Column A
Column C will consist of cost for each product mentioned in Column A
Column D will consist of employee name to whom the product is given
For Column D, I create a list of Column B through data validation>list

When I select a code in Column D, I need the pricing of the particular product to be displayed in Column E & F to consist of the employee name.

Can any one please let me know how I can create a file as mentioned above.

Thanking you in advance
Ajay

[sput_sput]

can you attach a workbook so i can see what you mean?

[ajay20616]

Ok, let me put it in simple way

I am attaching a file with this post example.xlsx

When I select "a" in column A, I want only "1 to 5" to be displayed in column B as list in drop down which can be selected by the user
When I select "b" in column A, I want only "6 to 10" to be displayed in column B as list in drop down which can be selected by the user
When I select "c" in column A, I want only "11 to 15" to be displayed in column B as list in drop down which can be selected by the user
When I select "d" in column A, I want only "16 to 25" to be displayed in column B as list in drop down which can be selected by the user
When I select "e" in column A, I want only "25 to 30" to be displayed in column B as list in drop down which can be selected by the user

In short a separate list should be displayed in column B for the one selected in column A

Thanking you in advance for helping me out

[FDibbins]

Hi and welcome to the forum

The file you posted does not resemble anything that you described in your 1st post I think you have tried to make the sample file too simplistic. I think it would help if you made your sample file a bit more realistic compared to your actual file (but no sensitive data), along with a few sample answers and how you arrived at them. That way we can help you put together a formula that will give you what you want, 1st time around, without having to guess at anything

[newdoverman]

Is this what you want....just taking a guess.

[ajay20616]

As per FDibbins post, I am attaching a file here. webdirectory script.xlsx

Now in the file that I have attached, there are 5 different types of heading (column A)
1) Mobiles
2) Electronics & technology,
3) Pets & pet care
4) Community
5) Events

Now, I want to create a drop down list for the headings as mentioned above. When I select "Mobile" from the drop down list I want only the ones related to mobiles to be shown in column B in a drop down box.

This should apply for all the headings. i.e, I select a heading (events) and list for the events should be displayed in column B in a drop down box.

I think that this will help to understand what actually I am trying to create.

Thanks.
Ajay.

[FDibbins]

lol sorry to seem like I'm "busting" on you (Im not), but many members cannot (or are reluctant to) access file hosting sites like that - company firewalls and stuff. You uploaded the first file here, please upload the 2nd 12 here too

Thanks

[ajay20616]

I wasn't' been able to get ur point.However, I am attaching the file again

webdirectory script.xlsx