Display message (via formula) if 2 values on Tab 4 are not on Tab 6

[surkdidat]

Hi all

I am in need of help - I have Tab 4 and Tab 6 in my workbook.

Following specific criteria I need a message to be displayed in Column M, if certain criteria are NOT met.

I need the formula to compare the Product ID, and Attribute, IF Column F is "ADD" and Column K is "ABC".

If there Product ID AND the attribute are NOT, I want it to say "Type ABC - Not on Tab 6"

I am usingthe following formula, but it does not appear to try and match both values in the same row

=IF(AND(F2="Add",$K2="ABC",(ISERROR(AND(MATCH(C2,'TAB 6'!$D:$D,0),MATCH(E2,'TAB 6'!$F:$F,0))))),"Type ABC- Needs To Be Added Onto Tab 6","")

TAB 4

Column C - Product ID	Column D - Product Name	Column E - Attribute	Column F - Add/Remove	Column K - Type	Column M - ERROR
12345	Horse	Hoove Size	Add	ABC
12346	Pony	Hoove Size	Add	ABC	Type ABC - Not On Tab 6
12346	Pony	Fur/Hair Colour	Add	XYZ
12345	Horse	Tail Colour	Add	ABC	Type ABC - Not On Tab 6

TAB6

Column D - Product ID	Column E - Product Name	Column F - Attribute	Column G - Add/Remove	Column H - Type
12345	Horse	Hoove Size	Add	ABC
12346	Pony	Fur/Hair Colour	Add	XYZ

 

[Wookiee]

This worked for me in a dummy workbook I created.

=IF(AND($F2="Add",$K2="ABC"),IF(COUNTIFS('Tab 6'!$D:$D,$C2,'Tab 6'!$F:$F,$E2)<1,"Add to Tab 6",""),"")