Hi Jane,
sorry, I can't help but I'm wondering the same problem.

A B C D E F
date km litre *l/100km litre2 **l/100km

Only problem I have is that column E might have various amount (1-9) blank
cells and total usage must be counted from previus km that e-column has
number.

Let's hope someone has solution in this problem :)

"jane" kirjoitti:

This is my formula

'=IF(ISBLANK(VLOOKUP($L11,'Past RDW
'!$L$3:$AI$780,16,FALSE)),"",(VLOOKUP($L11,'Past RDW
'!$L$3:$AI$780,16,FALSE)))

I am getting #NA when there is not a match so need to have a combo of
isblank and iserror... is this possible?

thanks in advance! jane