how do i add in numbers automatically based on adjacent cells cont

[lemskibar]

I'm trying to automatically enter data into multiple cells based on one cells
data.

For instance if a cell in column A = 1 then the adjacent cells in columns B,
C and D will all have specific values which will be true for a value of 1 in
column A.

If the value in the cell in column A = 2 then the adjacent cells in columns
B, C and D will have another set of specific values which will be true for a
value of 2 in column A and so on.

I think lookup tables is possibly the answer but the help isn't much good
and I am struggling!

[pinmaster]

Find an out of the way part of your worksheet, in the first column put 1,2,3 and so on, then input the corresponding values in the other columns, once you have done that you can use a VLOOKUP formula to retrieve your data

=VLOOKUP($A1,$N$1:$O$20, column(B:B),0)
copied down and across

A1 being the value to lookup
and
$N$1:$O$20 being the range where you put your data

I suggest inserting a blank worksheet, creating your table then hitting CTRL+F3 and giving your table a name....say table1, you can then use that name in your formula, you can then HIDE your worksheet.

=VLOOKUP($A1,table1,COLUMN(B:B),0)

HTH
JG

[RagDyeR]

In an out--the-way location, create a datalist that contains your values.

Say W1 to W25 contain the numbers 1 to 25.

X1 to Z25 contain the data pertaining to the Column W values.

In B1 enter this formula:
=VLOOKUP(A1,$W$1:$Z$25,2,0)

In C1 enter this formula:
=VLOOKUP(A1,$W$1:$Z$25,3,0)

In D1 enter this formula:
=VLOOKUP(A1,$W$1:$Z$25,4,0)

Does this do what you're looking for?


--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"lemskibar" <[email protected]> wrote in message
news:[email protected]...
I'm trying to automatically enter data into multiple cells based on one
cells
data.

For instance if a cell in column A = 1 then the adjacent cells in columns B,
C and D will all have specific values which will be true for a value of 1 in
column A.

If the value in the cell in column A = 2 then the adjacent cells in columns
B, C and D will have another set of specific values which will be true for a
value of 2 in column A and so on.

I think lookup tables is possibly the answer but the help isn't much good
and I am struggling!