Vlookup problem

[Barrowlad]

Hi, I have this formula which uses vlookup and I want it to use the cell H1 that offsets the result by 4.
I cannot get it to work is there anyway please.
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=IFERROR(VLOOKUP($A32,Results!$AP$10:$AS$17,4+H1,0),"")

Len
[/FONT]

 

[steve the fish]

What do you mean offsets the result by 4?

 

[Barrowlad]

Very sorry I will try to explain it better, it starts off like this,
=IFERROR(VLOOKUP($A32,Results!$AL$10:$AS$17,4,0),"")
A32 is on a sheet called Avg and the cell with the formula is on Avg cell C32, AI1 is on sheet Results and gets updated by 4 with a macro and I want I am trying to do is:
IFERROR(VLOOKUP(A32,results!AL10:AS17,AI1,0),””)
So That the next cell to C32 which is D32 and son on gets updated by 4.
Thankyou for replying
Len

 

[steve the fish]

Still not sure im understanding. Do you mean you want to drag the formula to the right and increment the column number that the formula returns by four?

 

[Barrowlad]

Yes please.
Len

 

[steve the fish]

Try this out and see if its what you mean

=IFERROR(VLOOKUP($A32,Results!$AL$10:$ZZ$17,COLUMNS($A$1:A1)*4,0),"")

 

[Barrowlad]

Thankyou very much, that works fine.
Len