Hi All,

I'm not sure if what I require is possible in excel.

I would ilke to add a batch of numbers in column A and then have Column
B display the numbers then in column C additional information relating
to data.

Eg:

Column A (Variable data)

0401123123
0401123124
0401123125


Then Column B will display (Variable data depending info in column A)

0401123123
0401123123
0401123123
0401123124
0401123124
0401123124
0401123125
0401123125
0401123125

Then Culumn C will display (Fixed Data)

Info 1
Info 2
Info 3

Any help would be appreciated.

Rgds
Dolphy

Hi Dolphy,
I think your post may be missing some details about your problem?...

because if I understand correctly, you want column A to contain data,
Column B to contain the same data & column C to contain different
data.
This is very easy in Excel, just type it into the cells you want it
in.

If you have certain values that are to be displayed in column C based
on the other columns, I suggest pressing F1 & typing "if worksheet
function" in the question area of the help window that appears & seeing
if you can use that to help you.

Hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=524176

the last part of your question can also be accomplished with vlookup.If you
have a table somewhere relating info 1 with 0401123123.So in colc 1 which say
lloks at b1 you will have the formula
=vlookup(b1,040_info_table,2,false).Your able will have your 040 numbers down
the lh column with the respective info value in the cell in the next column

--
paul
remove nospam for email addy!



"broro183" wrote:


Hi Dolphy,
I think your post may be missing some details about your problem?...

because if I understand correctly, you want column A to contain data,
Column B to contain the same data & column C to contain different
data.
This is very easy in Excel, just type it into the cells you want it
in.

If you have certain values that are to be displayed in column C based
on the other columns, I suggest pressing F1 & typing "if worksheet
function" in the question area of the help window that appears & seeing
if you can use that to help you.

Hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=524176