Excel addicts please help me : hi friends i need urgent help regarding my projects .there is two sheets(sheet1&sheet2) in my excel file its like daily work routine (entry date,pickup date,,dispatchal date  )   some details will cange as per the work flow and even new entries will appear.i just need to compare both file if there change  occured in one cell  its must have to show entire row of sheet1 (i cant specify exact headline for that  all details are too presious and even its have more than 100 headlines .
so if there any formula for that please let me know like
IF+VLOOKUP
please correct below given formula
=If(RECHERCHEV(A2,sheet1!A8:FM264,1,FAUX)=(RECHERCHEV(A2,sheet2!A8:FM257,1,FAUX);"";RECHERCHEV(A2,sheet1!A8:FM264,1,FAUX))
its french version
