How to subtract cell with the help of VLOOKUP or any other function/formula

[GAURAV SEMWAL]

how can I subtract current day data from previous day data with in a same month in complete worksheet, for example to get the value in cell N9 that is cell M9-P12 & cell N8 that is M8-M9, how can I get the value automatically

 

[Legacy 143009]

This is an example for your current scenario but you can configure this for your all sheet:

=M9-VLOOKUP($L9-1, $L:$P, 5, 0)

To make this more general:

=M9-VLOOKUP($L9-1, $L:$U, COLUMN(E1), 0)

So when you move to colum Q, the formula eventually become:

=Q9-VLOOKUP($L9-1, $L:$U, COLUMN(H1), 0)

 

[GAURAV SEMWAL]

This is an example for your current scenario but you can configure this for your all sheet:

=M9-VLOOKUP($L9-1, $L:$P, 5, 0)

To make this more general:

=M9-VLOOKUP($L9-1, $L:$U, COLUMN(E1), 0)

So when you move to colum Q, the formula eventually become:

=Q9-VLOOKUP($L9-1, $L:$U, COLUMN(H1), 0)[
[/QUOTE]
First of all thanx for the reply. Sir if i do l minus 1 then there  will be an error because like L8 has 31 October and L9 has 28 October then I want data by subtracting 28 from 31 but I am  getting error and how to solve it.

 

[Legacy 143009]

Ohh.. You don't have 29 October. So maybe you should look for closest match. Oaste this to N9:

=M9-VLOOKUP($L9-1, $L:$U, COLUMN(E1), 1)