Hi,
I'm trying to VLOOKUP a 5/31/2008 date in a table, but I am getting #N/A. I am quite sure same date exists in the table where I am looking.
Upon evaluating the formula, I noticed that 5/31/2008 is converted by excel into some decimal value (where it should be 39599). The whole number part of 39599 is correct but it is the decimals after this that are causing problems in excel to Vlookup.
I would appreciate if anyone could help.
Thanks
Bookmarks