How to see if 1 is supplied by A

[Tmmmmy]

Hi all,

Somehow Xl2bb was not allowing me to create a mini sheet so I've added a picture.

A product can be supplied by more than 1 supplier. However I want to find out if at least supplier "A" is supplying.
If any product is supplied by supplier "A" I want the cell to say "Yes". if any product is not supplied by "A", I want the cell to say "No".

Can anyone give their advice?

Regars,

Tim

 

[AlanY]

try this

Book1
	A	B	C	D	E
1	Product	Supplier		Product	Supplier A
2	1	A		1	YES
3	1	B		2	YES
4	1	C		3	No
5	2	A		4	No
6	2	B		5	No
7	3	B
8	3	C
9	4	C
10	5	B
Sheet2

Cell Formulas
Range	Formula
E2:E6	E2	=IF(COUNTIFS($A$2:$A$10,D2,$B$2:$B$10,"A"),"YES","No")

 

[Tmmmmy]

That seems to have worked, thanks a lot! Was breaking my head over this for quite some time..

 

[AlanY]

That seems to have worked, thanks a lot! Was breaking my head over this for quite some time..

you're welcome