Previous Topic Next Topic

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.


Related:

1 response

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


Is that what you want?
Mase
Nov 13, 2015 at 02:43 PM
no sorry, i want to type J2 in one box and have another cell look in J2
Mase
Nov 13, 2015 at 02:44 PM
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 26
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)"
Mase
Nov 13, 2015 at 02:51 PM
That is exactly what i was looking for thanks a million

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses