Hi, I have 2 spreadsheets. First one is an older one (with email address that we need) and the 2nd is the same (but no email address). There is a field for "Status" that is either open, pending or closed. We basically need that field updated on the older one (w emails) to reflect if the status has changed from open, pending or closed based on the 2nd ones value.