IF Formula with 2 conditions and 2 sheet references

Yeshaya

 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!

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.