Need help creating some associations of words

[maxcong]

Hello everybody,
I'm doing some statistics and i need to make a list of names, and to these names i need to associate some words.
This is how i should do this (theoretical, algorithm) :
Sheet2 :
Two columns :
- in the first column i will make a list of product names, each product name will be on a separate cell.
- in the second column i will type abbreviations corresponding to each product name.

Please Login or Register  to view this content.

Sheet3 :
Again two columns :
- in the first column i will make a list of customers( First and Last name).
- in the second column i will have to make a drop-down list corresponding to each customer name, the elements of each drop-down list will be the product names that i added in the Sheet2, first column.
Sheet1 :
Here's my problem.
Two columns :
- in the first column i will make a drop-down list with customers names that i added on Sheet3, column 1.
- in the second column i will make a list, that will automatically fill with the abbreviation of the corresponding customer's product name, from Sheet3.

Please Login or Register  to view this content.

Thank you in advance.

[FDibbins]

perhaps it would be easier to help you if you uploaded a sample workbook, showing what data you are working with, a few examples of what your expected outcome would be, and how you would arrive at that (remove any confidential info if necessary).

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[tigeravatar]

maxcong,

Welcome to the forum!
Attached is an example workbook based on the criteria you described.
In 'Sheet1' cell B2 and copied down is this formula:

Please Login or Register  to view this content.

[maxcong]

maxcong,

Welcome to the forum!
Attached is an example workbook based on the criteria you described.
In 'Sheet1' cell B2 and copied down is this formula:

Please Login or Register  to view this content.

Thank you kindly, that's the solution i was looking for, and also thank you for welcoming me to the forum.
Have a nice day!