Compare text values in 2 columns, and ignore blank cells

[NicholasH]

Hey guys,

I'm just wondering if anyone can help me with writing a formula for comparing values in 2 columns and ignore blank cells please?

For the example below:

If the values match or if there's a blank, then show up as "Okay"
If the values do not match, then show up as "Bad"

A	B	C	D
Item 1	3		Okay
Item 3	2	2	Okay
Item 4	4	5	Bad

Thanks so much in advance for any help!

 

[DanteAmor]

Try this

Book1
	A	B	C	D
1
2	Item 1	3		Okay
3	Item 3	2	2	Okay
4	Item 4	4	5	Bad
sheet

Cell Formulas
Range	Formula
D2:D4	D2	=IF(OR(C2="",B2="",B2=C2),"Okay","Bad")

 

[NicholasH]

Yeah, that's perfect! Thanks so much ???

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.