Comparison formula

[Exodus_1975]

Here is my problem: I have a spreadsheet with thousands of row and 20+ columns. One report is from last fiscal quarter and one is from the current quarter. I will combine them on one spreadsheet. So, I'm looking for a formula that can look at one reports data and find that cell A1 matches cell F1 on the data from the other report (on same spreadsheet). If it finds a match, I then want it to compare cells A2, A3, A4 and A5 to F2, F3, F4 and F5. If all of those cell match, I want it to return a special character or word of my choice. Note: cells will have dates and dollar amounts. PLEASE HELP ME MAKE MY JOB JUST A LITTLE BIT EASIER! Thanks, people.

 

[Travis]

Try this

=IF(AND(A1=F1,A2=F2,A3=F3,A4=F4,A5=F5),"MATCH","NO MATCH")

 

[Sauron]

Exodus - I had the same exact problem (I'm in accounting). Try excel overlay. It compares two spreadsheets and displays the differences between them. Good luck.

http://download.cnet.com/Excel-Overlay/3000-2077_4-10963782.html?tag=mncol