VLookup returning incorrect values?

[hijinxx]

I am using vlookup to return values from a second sheet, it is working fine for the first 11 rows but then repeats the same numnber and I cant figure out why?

Thanks in advance for any help.

[Russell Dawson]

You are asking it to lookup 14/09/10 but the data does not extend beyond 13/09/10 and the replication is of the very last cell

[Richard Buttrey]

Hi,

Two problems.
1.There are no 14 September dates on sheet 2.
2. You are using a 'True' argument as the 4th parameter in the VLOOKUP. This is looking for an approximate match and finds the last available date prior to the 14th September.

Change the final parameter to "False" and the formula will return 'N/A'

[hijinxx]

Ah of course. That was stupid of me. Didn't see the wood from the trees. Thank you both. : )