Tell excel where to look

Solved/Closed
Mase - 13 Nov 2015 à 14:38
 Mase - 13 Nov 2015 à 14:51
Hello,
I am trying to make a cell return a word when you tell it which cell to look in for that word.
If i type J2 in a box i want a cell to then look in J2 and return the value, so say november is in J2 thats what i want this cell to show.


Related:

1 response

RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 26
13 Nov 2015 à 14:40
=J2


Is that what you want?
no sorry, i want to type J2 in one box and have another cell look in J2
So i type J2 and the cell below where i typed J2 returns november
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 26
13 Nov 2015 à 14:47
Ok, so in J2 you type "November"
Then in another cell say, A2,you type "J2"
To return the contents of J2 referred to by A2, in another cell type "=INDIRECT(A2)"
That is exactly what i was looking for thanks a million