You can post as you find them and not all at once if you want...
1. Take a look at two features "Compare and Merge..." and "Compare Side by Side"
2. Put the date in the cell (i.e. A1). In the next cell put in a forula for that cell +1 (i.e. =A1+1).
3. VLookup assumes that the data is sorted based on the first column. So a column sorted out of order (i.e. 5,4,1,6,8) will not work. The column must be in the correct order (i.e. 1,4,5,6,8). If you do not put "False" as the last value of the vlookup formulas as opposed to leaving it blank or putting in "True", it will find the closest match. You need to give more detail on the type of results you are getting back here for more help.
I'm running Microsoft Office Excel 2003 and trying to do a spreadsheet comparison. Basically I want to compare several different columns from one spreadsheet to another, I'm almost positive that this can be done but can't remember how. Can anyone point in the right place? The other formula I need to create is to take a date format plus 1. For ex: I would like to have a column with dates entered 06/05/2006 and I would like to have the column next to it take that date and add 1 so that my result would be 06/06/2006. Lastly, I'm having some strange formatting issues when I'm trying to use v-look up. I have a report that I run from two different places that gets exported to excel and when I try to use v-lookup it just won't work there is some formatting issue when these reports export even though they contain the same information. Also, I have tried reformatting columns and tried copying and pasting the entire sheets as values only. I would appreciate any help anyone could offer.