Tell excel where to look

Solved/Closed
Mase - Nov 13, 2015 at 02:38 PM
 Mase - Nov 13, 2015 at 02:51 PM
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.


1 reply

RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 25
Nov 13, 2015 at 02:40 PM
=J2


Is that what you want?
1
no sorry, i want to type J2 in one box and have another cell look in J2
0
So i type J2 and the cell below where i typed J2 returns november
0
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 25
Nov 13, 2015 at 02:47 PM
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)"
0
That is exactly what i was looking for thanks a million
0