software

Hi

Can anyone help me how to write a matching formula please...
I'd like to match Column B from Colum A, then place number 1 if match found.

Also note: I have handred to items to match in Column A and Column BThank you in advance
SothCol.Col.Col.
ABC

JonPeter
JaneMichelle
JoeJon1
Michael
Jason
Joe1
Wang
Jashua
Jane1=IF(COUNTIF($A$1:$A$100,B1)gt;0,1,quot;quot;)

Change range of A as required

HTH

quot;Sothquot; wrote:

gt; Hi
gt;
gt; Can anyone help me how to write a matching formula please...
gt; I'd like to match Column B from Colum A, then place number 1 if match found.
gt;
gt; Also note: I have handred to items to match in Column A and Column B
gt;
gt;
gt; Thank you in advance
gt; Soth
gt;
gt;
gt; Col.Col.Col.
gt; ABC
gt;
gt; JonPeter
gt; JaneMichelle
gt; JoeJon1
gt; Michael
gt; Jason
gt; Joe1
gt; Wang
gt; Jashua
gt; Jane1
gt;

=ISNUMBER(MATCH(A2,B:B,0)) 0

Soth wrote:
gt; Hi
gt;
gt; Can anyone help me how to write a matching formula please...
gt; I'd like to match Column B from Colum A, then place number 1 if match found.
gt;
gt; Also note: I have handred to items to match in Column A and Column B
gt;
gt;
gt; Thank you in advance
gt; Soth
gt;
gt;
gt; Col.Col.Col.
gt; ABC
gt;
gt; JonPeter
gt; JaneMichelle
gt; JoeJon1
gt; Michael
gt; Jason
gt; Joe1
gt; Wang
gt; Jashua
gt; Jane1
gt;