accessing a cell that can change from query to query

[kenman]

Hi,
I am working with a spreadsheet that has about ten columns. I would like to have a calculation in the 1st of column, addition, subtraction, etc that would be using the data in 2 or more of the other columns. I am looking to change this data so I am looking to have either a formula in each cell in column "A" that I can change the columns that are in the formula.
For example-I was trying to figure out if there was some way that if I put in cell(1,1) a "3" referencing column 3 and in cell(1,2) say a "5"(refencing column 5). Is there anyway to write a formula in the cells in column 1 that would access the cells in the same row and know which columns I would like to use?
I am trying to do this in VBA, as I'm sure there is an easy way to do it, but I haven't gotten it to work yet.

Thanks for your time and I hope you understand the question.

Ken

 

[erik.van.geit]

Hello, kenman
Welcome to the Board !!!

is this something you could use ?
in A1: 3
in A2: =INDEX(B2:G2,$A$1)
result would be the value in D2, which is the 3th cell of the range B2:G2

although being a real VBA-fan, I don't see why you would do this in VBA
can you clarify a bit if you still want VBA

kind regards,
Erik

 

[kenman]

thanks

Hi Eric and Mr.Excel

Sorry it's taken so long to get back to you, but I just wanted to say thanks for the help with this. It seems to be just what I needed.


Kenman