Excel Help

  • Thread starter Thread starter Kyrpto
  • Start date Start date
K

Kyrpto

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 differen
data.
This is very easy in Excel, just type it into the cells you want i
in.

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

Hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience..
 
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
 
Back
Top