Double Cross
New Member
- Joined
- Sep 15, 2011
- Messages
- 9
Good Morning,
I am trying to create an IF formula to check if data in 2 columns match. The criteria is if column A has a "-V" at the end of the document number and column B is attributed it's correct. If column A document number has a "-V" at the end and column B is not attributed it's incorrect (like row 2). If column A document number doesn't have a "-V" at the end and column B is attriuted it's incorrect (like row 3).
Column A
Row 1 005B-230-05-A01-0001-V
Row 2 005B-230-05-A01-0002-V
Row 3 005B-230-05-A01-0003
Column B
Row 1 SDR-ALL TAGS-1
Row 2
Row 3 DR-230HI501-1
Thanks
I am trying to create an IF formula to check if data in 2 columns match. The criteria is if column A has a "-V" at the end of the document number and column B is attributed it's correct. If column A document number has a "-V" at the end and column B is not attributed it's incorrect (like row 2). If column A document number doesn't have a "-V" at the end and column B is attriuted it's incorrect (like row 3).
Column A
Row 1 005B-230-05-A01-0001-V
Row 2 005B-230-05-A01-0002-V
Row 3 005B-230-05-A01-0003
Column B
Row 1 SDR-ALL TAGS-1
Row 2
Row 3 DR-230HI501-1
Thanks