http://www.aeoneye.com/other/clientlistpaid.xls
I need to match cells from 3 columns with 3 columns on a separate worksheet, then state "Yes" or "No" on whether or not they match. I attached a link to an example. There are two worksheets, "Jobs Complete" and "Jobs Paid". On Jobs Complete, I have a column for (A) date, (B) code, (C) name and (D)paid; and on Jobs Paid it is only A,B and C.
In the example, John has bought 3 services, but only paid for 1. The formula needs to match the client information from "Jobs Paid" tab. If they are not listed on this tab, it should say "No" under the Paid column on the "Jobs Complete" tab . I put examples under "Paid" as to what the formula should do. I would also like to know what to do if I need to add more than 3 columns to the formula. Thanks.
~Aeoneye
I need to match cells from 3 columns with 3 columns on a separate worksheet, then state "Yes" or "No" on whether or not they match. I attached a link to an example. There are two worksheets, "Jobs Complete" and "Jobs Paid". On Jobs Complete, I have a column for (A) date, (B) code, (C) name and (D)paid; and on Jobs Paid it is only A,B and C.
In the example, John has bought 3 services, but only paid for 1. The formula needs to match the client information from "Jobs Paid" tab. If they are not listed on this tab, it should say "No" under the Paid column on the "Jobs Complete" tab . I put examples under "Paid" as to what the formula should do. I would also like to know what to do if I need to add more than 3 columns to the formula. Thanks.
~Aeoneye
