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

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!

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

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" wrote in message
...
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!

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

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


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=495543