VLookup

Originally Posted by daddylonglegs

Try like this

=IF(COUNTA('1'!$A:$A),IF(COUNTIF('1'!$A:$A,Total!$A2),VLOOKUP(Total!$A2,'1'!$A:$C,3,FALSE),0),"")

Thanks, this works. However, I now appear to have a problem with the data I am importing. I have attached an exmple file.

Worksheet '1' has data I have manually keyed in and this is reflected in column 'D' of the Total sheet.

Worksheet '2' has data I have imported from the daily file and this returns zeros where I would expect in Totals column D (vehicle not in file) but the vehicles which ARE present in the daily file are producing an Invalid Cell Reference Error.

Can anyone tell me why?