How to cross check the formual in worksheet.

Hi All,

Greetings for the Day !

I have a excel a file which contains multiple sheets. Each sheet has its own calculations and data. I need to verify/cross check the data across all the tabs before making final decision.

Below is the one example of formula which I use in Consolidated sheet to get the final decision. Sometimes when I delete any rows from any of the depended(source sheet), the formula is getting mess up.
I want to build a check that supposed to be verify the data is pulling from all the sheets is correct. The key here is cell numbers.

Eg. In consolidated sheet, the cell should contain the formula which is checking the same cells data from different sheets.


In C6 cell the formula is ‘=IF(OR(Bberg!I6="NO",'IB'!L6="NO",'Research'!L6="NO"),"NO","YES")’


I can use Indirect/Address functions to build dynamic formulas. As the size is already 40mb, I cannt write dynamic formula. It may have impact on excel performance.(There are around 5000+ formulas in each sheet).

Please advise me.

Hi Tuph,

Sorry, I cannot upload the file as it contains lot of sensitive data. Even I cannt replicate some sample file also.

Hello Ford,

I need to delete those rows which are not needed in the file. its mandatory.


if you guys could help me in how to retrieve a string(Eg. 'Research'!L6) in the below case from a formula would be great. so that I can build the checks in the file.

In C6 cell the formula is ‘=IF(OR(Bberg!I6="NO",'IB'!L6="NO",'Research'!L6="NO"),"NO","YES")’

Thank you,
Vishnu V