Offset / VLookup Question

Spike

Board Regular
Joined
May 29, 2003
Messages
90
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

MrExcel MVP
Joined
May 15, 2003
Messages
8,638
Hi,

Try:

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

Spike

Board Regular
Joined
May 29, 2003
Messages
90
Offset / VLookup

Thanks Fairwinds - works nicely ......

Spike
 

Forum statistics

Threads
1,078,005
Messages
5,337,689
Members
399,160
Latest member
Vantone

Some videos you may like

This Week's Hot Topics

Top