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.
 

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

Back
Top