How to run two Loops with Counditions

[Abhijeet]

Hi

I have multiple file in one folder all files format is fix like sheet names and Template format.
I want to check Sheet 1 Data IF Add details word match in range E14:E100 this case is match.
Then Check Same Row from Column F to AJ Non Blank Cell If find non Blank cell then is any value in Upper cell if yes.
Then Give Number Name Which is mention in A & B COLUMN & file name Given in one sheet.
Please tell me how to do this

 

[Abhijeet]

Hi

Now I have mention expected result as well in this file.

Where is Add details mention in Column E then check range if any non blank cell if found any value then check above cell if any data or not if data found then this consider as in correct format & Below cell data is any value found then this is correct format.