Hi,

Let's consider the table below:

A B C
1 Invoice Line code Selection
2 2010030101 18 A
3 2010030101 2 A
4 2010030102 3 B
5 2010030102 3 B
6 2010030103 18 A
7 2010030103 6 A
8 2010030104 4 B
9 2010030104 6 B
10 2010030105 5 B
11 2010030105 2 B
12 2010030106 1 A
13 2010030106 1 A
14 2010030106 18 A
15 2010030106 2 A

May I know the formula to input at cell C2 in order to label each invoice
batch as "A" when one of its line codes is "18" ? Otherwise label it as "B".

Thanks

Low