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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need value from referenced cell 2
looking up cell address 1
Search for specific text within last non blank cell in a range 2
Use a cell to name a file to be opened. 3
use of ADDRESS function within CELL function 4
Formula Result is "V6", need Excel to use cell "V6", not the resul 3
Using Validation Ref # within LOOKUP 3
Cell Content Lookup Function 2

Back
Top