Checking as check box if 2 criteria are met

michael.vanhuss

I am trying to check a checkbox if the name and date on another sheet are on the sheet. Here is the code I have which is obviously not working.

=IF({2019 IA Tracker Range 2}, 5 / 23 / 19, {2019 IA Tracker Range 1}, [Vendor Contact]5, 1)

Where range 2 is the date and range 1 is the name.

Any help is appreciated.

Paul Newcome

Do the name and date need to be in the same row on the other sheet, or are you just looking to match to the name anywhere on the other sheet and the date anywhere on the other sheet?

 

Could you provide some screenshots and more detail? There are a few ways to go about this, but it depends on your setup and requirements.