using a number to select a cell

  • Thread starter Thread starter vrijbergen
  • Start date Start date
V

vrijbergen

Hi,

I am looking for a way to select a cell by using a number,

for example i want to use the number 5 (A5=5) to select cell D5 end t
put it at location Z1 so i something like: Z1= D & A5

I don't want to use Vlookup. Is this possible or do i have to us
Vlookup?
Or should i use Visual Basics editor? if yes can somebody help me wit
that?


Thanks Michie
 
What you want is not clear. Do you want to put a number in A5? And that
number instructs Excel to select some cell? What cell? And you want what
copied/moved to Z1? Post back with more detail. HTH Otto
 
Hi, check out the INDIRECT function. Something like ...

=INDIRECT(Z1)

... or ..

=INDIRECT("D"&A5)
 
Back
Top