Offset in the Formula bar (Excel)

[RamziSaab]

I was wondering if someone could help me with Excel.

basically what i have so far is the following

=VLOOKUP("fx",INDEX('G:\common\[SBILPL.xls]Coversheet - Flow Trading'!$A:$A,MATCH(B38,'G:\common\[SBILPL.xls]Coversheet - Flow Trading'!$A:$A,0)):'G:\common\[SBILPL.xls]Coversheet - Flow Trading'!$H105,4,FALSE)

but i need the second bit of the range to be really 6 rows less than the bit?
First bit:
INDEX('G:\common\[SBILPL.xls]Coversheet - Flow Trading'!$A:$A,MATCH(B38,'G:\common\[SBILPL.xls]Coversheet - Flow Trading'!$A:$A,0)):

Second bit

G:\common\[SBILPL.xls]Coversheet - Flow Trading'!$H105

is there anyway to make is look at 6 rows above the frist bit?

Any ideas would be really helpful!

 

[RamziSaab]

its ok i got it with some excel help!!

using the offset with the sencond bit works perfectly

i.e.

Offset(INDEX('G:\common\[SBILPL.xls]Coversheet - Flow Trading'!$A:$A,MATCH(B38,'G:\common\[SBILPL.xls]Coversheet - Flow Trading'!$A:$A,0)),-6,8)

basically it takes that reference and subtracts 6 rows from it and puts it 8 columns forward...

if there is an easier way to do this (even with vba) please tell me!