Comparing data within 2 spreadsheets

Hi Amit, Thank you for the post, welcome to the forum, in answer to your question, I would consider using the =EXACT( formula, however this will only check one cell against another, if the two lists are in columns and are next to each other ie Column A and Column B, in Column C place the formula =EXACT(A1,B1) this will compare the value in A1 with the value in B1 if they are the same it will return TRUE if not FALSE, you could then copy the formula down the list to check all your entries (Double click the fill handle). Note: This will also work with text entries.
I realise that I have given an example on just one worksheet but cross worksheet (3D) formulas will work as well.
If this is not what you are looking for, please come back and we can discuss it in more detail, if this has answered your question, please click the Resolved link, best regards Pete

Hi Amit, Thanks for your response, I still stick by my original answer, it is the only way that I can think of that will sort out your problem. regards Pete