Use cell content as cell address

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I want to store various cell adresses in lookup table, and
use lookup function to access to the content of the
referenced address. Please help!

Thanks,
Paul
 
Use the INDIRECT function.

For example, if cell B2 held the address "C5" the
following formula in a cell would result in the value
held in C5.
"=Indirect(B2)" - (leave out the "s)
 
Back
Top