Referencing data in another sheet when other sheet is continually expanding in an IF(AND situation

Doyle54

Sorry if my question is too simple but this is an important bit of coding. I am referencing a continually expanding sheet what would be the coding like:

Quarter1 is calculated in the Summary Sheet of the current sheet. Current Quarter1 is 04-2020.

I want to check if a value in a pad in a sheet (Well Pad List) matches a pad inspected in Pad Inspection Report Sheet.

=IF(AND(Combine Loc & Name1={Pad Inspection Report Sheet 7-7 2 [Combine Loc & Name]:[Combine Loc & Name]}, Quarter1= {Pad Inspection Report Sheet 7-7 2 [QTRfiscal]:[QTRfiscal}, 1,0)

Very Much Appreciated. Very important cell calculation.

Ramzi K

@Doyle54

Can you please include some screenshots? It would be a great help.

Cheers,

Ramzi

Doyle54

Well Pad List Image.jpg

Pad Insp 7-7 2.jpg

Sure.

Doyle54

Yellow background is automatically calculated and is normally hidden

Doyle54

Correction

=IF(AND(Combine Loc & Name1={Pad Inspection Report Sheet 7-7 2 [CombPN&L]:[CombPN&L]}, Quarter1= {Pad Inspection Report Sheet 7-7 2 [QTRfiscal]:[QTRfiscal}, 1,0)