match columns and add value

[philmatth]

Hi,
I'm hoping this is possible so any help would be greatly appreciated.
I need to add a value of 1 in column B where the pID in column C doesn't exist in column A

For example the pID of 30 does not exist in column A

Sheet1

*	A	B	C
1	ID	Remove_Product	pID
2	9	0	9
3	12	0	12
4	17	0	17
5	18	0	18
6	25	0	25
7	26	0	26
8	27	0	27
9	31	1	30
10	32	0	31
11	33	0	32
12	34	0	33

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:80px;"><col style="width:131px;"><col style="width:80px;"></colgroup><tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[gaz_chops]

Try

=IF(ISNUMBER(MATCH(C2,$A$2:$A$12,0)),0,1)

 

[philmatth]

Gaz - that's perfect, if you're ever in Blackpool I'll buy you a few pints

 

[gaz_chops]

Gaz - that's perfect, if you're ever in Blackpool I'll buy you a few pints

You're welcome, I'm not far from Blackpool so line them up

 

[XOR LX]

You'll have to fight off all the hen and stag parties first!

 

[philmatth]

It's the better part of the Fylde - Poulton near Blackpool Nice market town with normal people!!!