Using cell value as index to another cell

[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)

 

[Frank Kabel]

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)

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

Frank

 

[Chip Pearson]

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

 

[Roger Govier]

Hi Don

Try
=INDIRECT("X"&D18)

 

[JE McGimpsey]

One way:

=INDEX(X:X,D18)