Cell Referencing??

  • Thread starter Thread starter bob
  • Start date Start date
B

bob

I need some help to solve a referencing problem......
Cell A4 has the number 6 in it.
In another cell I wish to reference another cell based on the content of
cell A4
So in actuality the folmula would look something like the following, but of
course one cannot do this, so I need another way.....
=B5+H(A4) Of course, B5+H6 is what I'm after, but the 6 will change
depending of other things.
 
=B5+INDIRECT("H"&A4)

will do the job.

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.
 
Back
Top