Hi,

I've got a whole load of prices showing against dates and times in the format '03/01/2005 07:44:59'. I'm trying to use a vlookup on a different sheet to look up certain date and time combinations and return the price in the next column. e.g. =VLOOKUP((C11+$G$1),'Cleaned GLN'!$A$2:$E$169250,5,FALSE)

C11 has '03/01/2005' in it and G11 has '07:44:59'.

When i enter the above formula i just get #NA. When i try changing the 'false' to 'true' i get the previous row's price....

Any ideas?

Thanks very much
Jo