True or False Query \ Excact formaula in more than two sheets

Hi All.

I have attached a demo file containing three sheets where i want to ensure that Name on each sheet should be on exact cell address.

For Example:
in "First", "Second" & "Third" sheet Ram is showing on A2 Cell. It means its ok. BUT
"Roony" is not coming on A3 cell in second sheet, its not ok

I just want to ensure that I all my names are on correct cell address in different sheet.
Also we can make First sheet as Base file..that other sheets will follow

i can use exact formula but there are more than 3 sheets so finding it difficult to solve.

Hope you have understood my query.

Thanks in Advance.

If all you want is a TRUE/FALSE, try this, copied down...
=AND(A2=Second!A2,First!A2=Third!A2)

Originally Posted by FDibbins

If all you want is a TRUE/FALSE, try this, copied down...
=AND(A2=Second!A2,First!A2=Third!A2)

Thanks but in original I have more that 20 sheets in my excel file ... so how can i do this in a Quick way around.

apart from a very long and() statement, I cant think of anything off the top of my head

Try this UDF...

Please Login or Register  to view this content.

=CHECKDATA("CellAddress","StartSheetName","EndSheetName",Case Sensitivity True/False)

For Exact Match
=CHECKDATA("A2","First","Third",TRUE)

For No Case Sensititvity
=CHECKDATA("A2","First","Third",FALSE)