Creating a formula that looks for criteria in a range and searches for that combo in a row

Hello, I hope I explain this the right way.

I want to to find if a specific (row-level) combination of employee and date that exists on the first sheet also exists on the second sheet and if so, use a formula to flag the row that has the combination.


For example, if Alex and 06/16/20 exists on the first sheet, I want to create a formula that flags where Alex and 06/16/20 exists exists on the same row in the second sheet.


Thoughts?



Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!