I would like to do the following: Fill in a cell with an equal statement,
for ex, in cell B6 type "=n135". What I would then like to have happen is
cell d6 automatically fill with what is in p135 and for cell e6 to
automatically fill in with q135. I need the conditional because I want to be
able to change cell B6's value with different cell values, ie n245, n600, n4,
and have cells d6 and e6 automatically follow with the same row but different
columns.
Any help would be greatly appreciated.

Alini,

Use a VLOOKUP formula based on the value in cell B6, linked to the table.

For example, to get the value from column P, use this in D6:

=VLOOKUP(B6,$N$1:$Q$500,3,False)

And from column Q, use this in E6:
=VLOOKUP(B6,$N$1:$Q$500,4,False)

This assumes that the values in column N are unique.

HTH,
Bernie
MS Excel MVP


"AliniMag" wrote in message
...
I would like to do the following: Fill in a cell with an equal statement,
for ex, in cell B6 type "=n135". What I would then like to have happen is
cell d6 automatically fill with what is in p135 and for cell e6 to
automatically fill in with q135. I need the conditional because I want to be
able to change cell B6's value with different cell values, ie n245, n600, n4,
and have cells d6 and e6 automatically follow with the same row but different
columns.
Any help would be greatly appreciated.