icthus123
06-23-2007, 10:00 AM
I've created a spreadsheet which uses a data validation list for the data in one column A which conditionally produces a list for the next column B.
So far so good.
But what I'd like to do is have the next column C automatically populated with data based on the entry selected in column B.
Let me explain a bit more, the data for column B is stored in a table A with two columns in another spread sheet. The data from the first column in table A is what populates column B in the first sheet. The data in the second column in this Table A is what I would like to be automatically entered into column C on the first sheet!
For example say that table A appeared as thus
A E
B F
C G
D H
If the data selected in column B was "A" then the data automatically entered in column C would be "E" and if the entered data was "C" column C would have data "G".
This is what I'm not sure how to accomplish without an extremely elaborate IF formula which would have to be changed every time I entered new data into table A.
If I can help it I don't want to use any VBA for this as it's for a person at work who couldn't maintain it if it was too complex.
Have I explained myself clearly enough? And if so does any one have any ideas?
So far so good.
But what I'd like to do is have the next column C automatically populated with data based on the entry selected in column B.
Let me explain a bit more, the data for column B is stored in a table A with two columns in another spread sheet. The data from the first column in table A is what populates column B in the first sheet. The data in the second column in this Table A is what I would like to be automatically entered into column C on the first sheet!
For example say that table A appeared as thus
A E
B F
C G
D H
If the data selected in column B was "A" then the data automatically entered in column C would be "E" and if the entered data was "C" column C would have data "G".
This is what I'm not sure how to accomplish without an extremely elaborate IF formula which would have to be changed every time I entered new data into table A.
If I can help it I don't want to use any VBA for this as it's for a person at work who couldn't maintain it if it was too complex.
Have I explained myself clearly enough? And if so does any one have any ideas?