Reference
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)?
|