Auto Polulating text based on the text in a differnt cell?

[Peter Wuensch]

First thing I need to do is create a list of items to choose from for the cells in each column. Then I would like to know how do I populate a cell from a list of options based on the text from a list in a different cell? I have a column that will list the type of piece of equipment in a text format and from that cell I need to populate other cell. In other word from the defined list of options in the column that defines the "Type" of equipment will choose from a list of defined options for tha same row cell in the Service column, the description Column, the mounting column and the throw column. In other words, If the value of Cell B2 is "S-2" then the program will select the stated value associates with "S-2" from a list of items defined in cell E2, F2, G2, & H2.

 

[hiker95]

Peter Wuensch,

Welcome to the MrExcel forum.


We can not tell where your raw data is located, sheet name(s), cells, cell formatting, cell formulae, rows, columns, and, we can not tell where the results should be, sheet name, cells, cell formatting, cell formulae, rows, columns.


We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com