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

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.

Find more posts tagged with

Accepted answers

All comments

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)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.