software

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
0401123125Then 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 amp; 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 amp; typing quot;if worksheet
functionquot; in the question area of the help window that appears amp; seeing
if you can use that to help you.

Hth
Rob Brockett
NZ
Always learning amp; the best way to learn is to experience...--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=524176the 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!
quot;broro183quot; wrote:

gt;
gt; Hi Dolphy,
gt; I think your post may be missing some details about your problem?...
gt;
gt; because if I understand correctly, you want column A to contain data,
gt; Column B to contain the same data amp; column C to contain different
gt; data.
gt; This is very easy in Excel, just type it into the cells you want it
gt; in.
gt;
gt; If you have certain values that are to be displayed in column C based
gt; on the other columns, I suggest pressing F1 amp; typing quot;if worksheet
gt; functionquot; in the question area of the help window that appears amp; seeing
gt; if you can use that to help you.
gt;
gt; Hth
gt; Rob Brockett
gt; NZ
gt; Always learning amp; the best way to learn is to experience...
gt;
gt;
gt; --
gt; broro183
gt; ------------------------------------------------------------------------
gt; broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
gt; View this thread: www.excelforum.com/showthread...hreadid=524176
gt;
gt;