IF Formula with 2 conditions and 2 sheet references

Perhaps you can help me with the creation of the formula. I will paste what I have done so far but it is giving me an error.

=IF(VIN137 = {TOPSHEETS - Leasing Direct Range 1} {TOPSHEETS - Leasing Direct Range 3}>5/14/2020, {TOPSHEETS - Leasing Direct Range 2}"Star","")

I have a column (VIN) in a calendar sheet that will have numbers in a cell matching numbers in a cell from a different sheet (Range 1). If the numbers match and it is after the date of 5/14/2020, then the star column should place a star in the matching row. If there is no match after that date, then nothing should happen.

Please advise how I can correct this formula.

Thank you very much!

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Try something like this...

=IF(INDEX({Other Sheet Date Column}, MATCH(VIN@row, {Other Sheet VIN Column}, 0)) > DATE(2020, 05, 14), 1)

Yeshaya

Hi Paul,

I tried to follow your steps but there is still an error #Unapraisable.

=IF(INDEX({TOPSHEETS - LD Range 3}.MATCH(VIN137,{TOPSHEETS - LD Range 1},0)) > DATE(2020,05,14),1)

I appreciate you reaching out. Would you know why there is still an error?

Thank you.

Paul Newcome

You have a period instead of a comma before the MATCH function. Try swapping that out and see what happens.

Yeshaya

The error went away!

Thank you.

Paul Newcome

Happy to help! 👍️

Please don't forget to mark the most appropriate response(s) as "helpful" so that others searching for a similar solution can know that one may be found here.

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.