If 2 Criteria Met On Second Sheet, Display ID Number from Second Sheet on First Sheet
I am trying to write a cross-sheet formula in sheet 1 (field name is Row ID) to display the Row ID from a second sheet if the second sheet Newest field and ED field are both checked (see below).
I've been looking through posts and attempting INDEX/MATCH, nested IFs, etc. and nothing is working so far.
Any help would be very appreciated!
Help Article Resources
Check out the Formula Handbook template!