Tell excel where to look
Solved/Closed
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.
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:
- Tell excel where to look
- Number to words in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
- Excel marksheet - Guide
1 response
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
26
Nov 13, 2015 at 02:40 PM
Nov 13, 2015 at 02:40 PM
=J2
Is that what you want?
Nov 13, 2015 at 02:43 PM
Nov 13, 2015 at 02:44 PM
Nov 13, 2015 at 02:47 PM
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)"
Nov 13, 2015 at 02:51 PM