Hi,
I have the following formula that works to return a "Not Paid" or "Paid" response, however, I need to add another match criteria if it returns "Not Paid" to look up another data set and then either return "Not Paid" or "Paid" based on second match.
So, if "Not Paid" is returned then I would like to do another match in "[FILE-B.XLSX]DATA'!$K:$K" and then return "Not Paid" or "Paid" depending on if it matches or not.
Thank you.
I have the following formula that works to return a "Not Paid" or "Paid" response, however, I need to add another match criteria if it returns "Not Paid" to look up another data set and then either return "Not Paid" or "Paid" based on second match.
=IF(ISNA(MATCH(E1,'[FILE-A.XLSX]DATA'!$K:$K,0)),"NOT PAID","PAID")
So, if "Not Paid" is returned then I would like to do another match in "[FILE-B.XLSX]DATA'!$K:$K" and then return "Not Paid" or "Paid" depending on if it matches or not.
Thank you.