Help with a Vlookup nested IF statement

Hello! I would greatly appreciate some assistance in creating a formula to solve this. I've searched and tried multiple kinds of formulas and haven't found a solution yet.

I am trying to create a formula that will search for multiple matches across 2 sheets. The first has to match the Salesforce Case Number (column 1) in {Calibration: Chat (rev 3)} with the Salesforce Case Number (column 1) in {Calibration Key: Chat (rev)} before it can match (T/F) the criteria in the highlighted columns

My end goal is for the formula in the Score Helper column to produce a T or F depending if it matches but I need it to recognize and match the Salesforce Case Number to ensure it's looking at the correct key.

Future state will have multiple Keys listed so I need it to be able to match before it generates the T/F.

I have attempted to do a VLOOKUP with IF nested that didn't work. Not sure if a CONTAINS or INDEX would work better.

Please see the attached images of the 2 Sheets.

Screen Shot 2023-02-14 at 8.55.12 AM.png

Screen Shot 2023-02-14 at 8.55.32 AM.png

Find more posts tagged with

Accepted answers

Leibel S

@Katherine Cline

Not sure if this is what you are looking for, but will attempt:

Replace the bolded cross sheet references as needed

=IF(INDEX({Calibration Key - Initial Response Time}, MATCH([Salesforce Case Number]@row, {Calibration Key - Salesforce Case Number}, 0)) = [Initial Response Time]@row, "T", "F")

All comments

Leibel S

@Katherine Cline

Not sure if this is what you are looking for, but will attempt:

Replace the bolded cross sheet references as needed

=IF(INDEX({Calibration Key - Initial Response Time}, MATCH([Salesforce Case Number]@row, {Calibration Key - Salesforce Case Number}, 0)) = [Initial Response Time]@row, "T", "F")

Katherine Cline

@Leibel S

Thank you so much! That's exactly what I'm looking for!! It worked perfectly!

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.