indirect cell reference

[openyamind]

Hi,

I am wondering if it possible in excel to use a cell reference like A1+3 for Cell A4? Basically I want to be able to copy and paste data so the cell reference will go up by 3. It is actually for an array using the Vlookup function and It will be A1:C4 for the first reference then A4:C7 for the second, A7:C10 for the 3rd etc.

[FDibbins]

yes, you can use something lke shown below. change the references to suite...

=INDIRECT("A"&B17)

this would use the value A and whatever is in B17 (say 3), to return the value in A3

let me know how this works for you?

[openyamind]

thanks for your help but i still can't get it to work. The problem is not quite as straight forward as i originally posted as it is part of a vlookup function.
What I want to be ablte do is fill right to achieve the following sequence,

Cell A7 =VLOOKUP(A4,'Abut A SPlates'!$H$40:$K$44,B4,FALSE)
Cell B7 =VLOOKUP(A4,'Abut A SPlates'!$H$46:$K$50,B4,FALSE)
Cell C7 =VLOOKUP(A4,'Abut A SPlates'!$H$52:$K$56,B4,FALSE)
etc

[FDibbins]

i dont have much time left to help more, but try playing aound with....

=indirect("VLOOKUP(A4,'Abut A SPlates'!$H$"&A1":$K$A2&,B4,FALSE)") assuming the values you want to base the lookup on are in A1 and A2. change references as needed. if that doesnt work for you, im sure 1 of the real experts can help you

[openyamind]

Thanks for your efforts it's still not working but hopefully someone else will be able to help

[FDibbins]

could you perhaps send sample workbooks for me to play with?

[Ace_XL]

Try this maybe

In A1 input 'Abut A SPlates'!$H
In A2 input :$K
In A7 use
=VLOOKUP($A$3,INDIRECT($A$1&34+COLUMN()*6&$A$2&38+COLUMN()*6),$B$3,FALSE) and copy across