Tell excel where to look [Solved/Closed]

Report
-
 Mase -
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

Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
=J2


Is that what you want?
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3990 users have said thank you to us this month

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 August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
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