Look up 2 columns conditions and return 3rd column value

Hello Experts,

I want to look at values from Creation Week and CR_Current Week columns and return values from CR_Start Date. I have given the lookup criteria in Column G2 and G3 and want to return the value in G4.

=INDEX(ColumnD2:ColumnD14,MATCH(IF,(ColumnG2=ColumnB2:B14)*(ColumnG3=ColumnC2:ColumnC14),0))

=INDEX(ColumnD2:ColumnD14,MATCH(1,(ColumnG2=ColumnB2:B14)*(ColumnG3=ColumnC2:ColumnC14),0))

Find more posts tagged with

Sheets

Accepted answers

Paul Newcome

Happy to help. 👍️

All comments

Paul Newcome

You are going to want something along the lines of

=INDEX(COLLECT([CR_Start Date]:[CR_Start Date], [Creation Week]:[Creation Week], ColumnG2, [CR_Current Week]:[CR_Current Week], ColumnG3), 1)

Tamizamuthan Vedachalam

Thank you sir.. let me try this

Paul Newcome

Happy to help. 👍️

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.