Using cell value as index to another cell

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I need to use the numeric value in one cell as the index
to the value in another cell in another column.

Example:
If D18 holds a value of 50, I need to find the value in
cell X50? Where "X" can be any column. Any ideas?

Don
(e-mail address removed)
 
Don said:
I need to use the numeric value in one cell as the index
to the value in another cell in another column.

Example:
If D18 holds a value of 50, I need to find the value in
cell X50? Where "X" can be any column. Any ideas?

Don
(e-mail address removed)
Click to expand...

Hi Don
try
=INDIRECT("X" & D18)

Frank
 
Don,

You can use the INDIRECT function to do this. For example,

=INDIRECT("X"&D18)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top