Return a date from a row, on a different sheet, that corresponds with their name.

I have a sheet that I am trying to inform team members when their license expires and I am wanting a formula that looks at one sheet, if the name is there it return the corresponding value. I can get the formula to return yes or no but I need the exact date.

=IFERROR(IF(AND(MATCH($Name@row, {Team Member}, 0) > 0, COUNTIFS({Team Member}, $Name@row, {Pallet Jack}, <>"") > 0), "Yes", "No"), "Error")

This is the formula I started with.

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Mangan

=IFERROR(IF(AND(MATCH($Name@row, {Team Member}, 0) > 0, COUNTIFS({Team Member}, $Name@row, {Pallet Jack}, <>"") > 0), {Pallet Jack}, "No"), "Error")

I tried this formula, which is saying to return that value in that column and it is returning #DATE EXPECTED on the people who have dates, and "No" on the cells that are blank and don't have anything.

KPH

Hi @Paul Mangan

Have you tried an INDEX MATCH formula?

I can't see your sheets (I am guessing Pallet Jack is the date) but the formula will be something like

=INDEX({Pallet Jack}, MATCH($Name@row,{Team Member}, 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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.