Offset / VLookup Question

[Spike]

I've tried several permutations of Index / Match etc but still not able to alter or amend the following formula as required :

=VLOOKUP(B7,Sheet1!A5:C10,3)-Offset(VLOOKUP(B7,Sheet1!A5:C10,3),-1,0)

Basically just want to lookup one value and then subtract same reference from previous row in lookup table.

I know that offset and vlookup don't work together and it looks like there's quite a number of posts on this topic but as yet still struggling with solution.


Any help much appreciated....


Best Regards,


Spike

 

[fairwinds]

Hi,

Try:

=VLOOKUP(B7,Sheet1!A5:C10,3)-INDEX(Sheet1!C5:C10,MATCH(B7,Sheet1!A5:A10)-1)

 

[Spike]

Offset / VLookup

Thanks Fairwinds - works nicely ......

Spike