I have two reference sheets that I'm trying to connect to another sheet that will serve as a log. How it works: User enters information (VTH Code is associated with a vendor price on both the reference sheets). The user enters the price a client was charged. This is used to check if it matches either of the reference sheets and returns Yes or No to a new column.
I have successfully linked one sheet:
=IF(COUNTIFS({Outside Lab Tests - Small Animal Range 1}, CONTAINS(@cell, [VTH Code]@row), {Outside Lab Tests - Small Animal Range 3}, HAS(@cell, [Outside Lab Charges]@row)) > 0, "Yes", "No")
This works! Hurray!
But I'm struggling to get the other sheet connected so it checks both. I've tried both below:
=IF(COUNTIFS({Outside Lab Tests - Small Animal Range 1}, CONTAINS(@cell, [VTH Code]@row), {Outside Lab Tests - Small Animal Range 3}, HAS(@cell, [Outside Lab Charges]@row)) > 0, "Yes", "No"), OR({Outside Lab Tests - Large Animal Range 2}, CONTAINS(@cell, [VTH Code]@row), {Outside Lab Tests - Large Animal Range 1}, HAS(@cell, [Outside Lab Charges]@row)) > 0, "Yes", "No")
=IF(COUNTIFS(IF(COUNTIFS({Outside Lab Tests - Small Animal Range 1}, CONTAINS(@cell, [VTH Code]@row), {Outside Lab Tests - Small Animal Range 3}, HAS(@cell, [Outside Lab Charges]@row))), {Outside Lab Tests - Large Animal Range 2}, CONTAINS(@cell[VTH Code]@row), {Outside Lab Tests - Large Animal Range 1}, HAS(@cell, [Outside Lab Charges]@row))) > 0, "Yes", "No")
I feel like I'm close but can't quite figure it out. Thanks for any help pointing me in the right direction!
