I'm trying to get a cell to reference a cell which will display a different
cell depending on the number displayed in the reference cell. Ex.

Ref Answer 1(1) Answer 2(2) Answer
3(3)
display this cell
display this cell

display this cell

options of ref
1 or 2 or 3 have answer here

I hope this makes sense. I originally used =LOOKUP(1,A7,C3), then I get
stuck, am I on the right path (right formula)?

Your example is not very clear. Try describing to us what the number outside of the parentheses means and what the number inside the parentheses means (row/column maybe?). Where is the Ref at (in A7 maybe)?

--
Rick (MVP - Excel)


"Kmart03" wrote in message ...
I'm trying to get a cell to reference a cell which will display a different
cell depending on the number displayed in the reference cell. Ex.

Ref Answer 1(1) Answer 2(2) Answer
3(3)
display this cell
display this cell

display this cell

options of ref
1 or 2 or 3 have answer here

I hope this makes sense. I originally used =LOOKUP(1,A7,C3), then I get
stuck, am I on the right path (right formula)?

Hi,

If the cell where you enter ref (1, 2 or 3) is A1 and the answers should be
staggered then:

=IF(A1=1,"Answer 1","") in B2
=IF(A1=2,"Answer 2","") in C3
=IF(A1=3,"Answer 3","") in D4

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Kmart03" wrote:

I'm trying to get a cell to reference a cell which will display a different
cell depending on the number displayed in the reference cell. Ex.

Ref Answer 1(1) Answer 2(2) Answer
3(3)
display this cell
display this cell

display this cell

options of ref
1 or 2 or 3 have answer here

I hope this makes sense. I originally used =LOOKUP(1,A7,C3), then I get
stuck, am I on the right path (right formula)?