vlookup not working, sumif does.

[Stripey]

Alright it's been a while since my last post, but I've come across another odd problem that I can't fix by myself.

I have a spreadsheet that is trying to return data from a master sheet. Now it has 12 months listed in a column, with data for each month beside it. The child sheets draw data from the master sheet. By doing a simple vlookup on the dates. One month does not work. All months work aside from July 2007. The same cell DOES work when I type in a different month. The formatting has been changed between general, text and custom date. I have also copy/pasted the date between the cells to ensure they are identical.

The worst part is the same name I have some concatenates in another cell that reads from the date and those cells work fine, its just 2 cells causing the issue.

I made a sumif for the cell and it reads the data fine, but when I change it back into a vlookup it just reads 0% instead of the 9% that is there.

If there is anything else I can mention about this issue that will help fix it just let me know I'll put it up asap.

Thanks!

[corinereyes]

Hi,

Can you post a sample of the file?