Look Up

[minrush]

I have series of numbers on A colum and B colum.

I need to formula that'll give me 1 if B number is in A..
And give me 0 if B number is not in A..

Please Help...

 

[VoG]

Try in C1 copied down

=IF(ISNUMBER(MATCH(B1,A:A,0)),1,0)

 

[Glory]

If B equals A exactly, or if a part of B is present in A?

 

[T. Valko]

I have series of numbers on A colum and B colum.

I need to formula that'll give me 1 if B number is in A..
And give me 0 if B number is not in A..

Please Help...

Try this...

Book1
	A	B	C
1	1	2	1
2	2	15	0
3	3	7	1
4	4	12	0
5	5
6	6
7	7
8	8
9	9
10	10
Sheet1

Enter this formula in C1 and copy down as needed:

=--(COUNTIF(A:A,B1)>0)