I'm trying to get VLOOKUP to recognize / select a date from a column of dates arranged in chronological order (and return the corresponding value in another column). Problem: the function doesn't seem to want to recognise for example 28/6/2013 but only the same value in serial date number format (41453). I can add a column with the two formats side by side but the idea is to input and look up a date that means something, not a number!! I think in Quattro there was an @@ function that returned a referenced cell, which might have worked somehow, but trying around with OFFSET and INDIRECT hasn't brought a solution. I've a feeling that there's a solution staring me in the face but can anyone help with a wee bit lateral thinking?