Compare two lists

[wrxmania]

Hi:

This is my scenario: I have data in two columns and I want to see which ones from column A is also available in Column C

A: Inventory
876-WI
764-IL
334-AL
785-WA
657-MT

Column C: Sold
657-MT
334-AL
876-WI

So in column B I want to put a formula which will identify whether an entry in column A is also present in B or not. That way I can count the inventory in hand.

 

[jeffreybrown]

Something like this...

Excel Workbook
	A	B	C
1	a	1	a
2	g	0	b
3	c	0	*
4	d	0	*
5	e	0	*
6	f	0	*
7	a	1	*
8	h	0	*
Sheet12

 

[wrxmania]

Thanks for your quick reply. If I input the following function, would it put NonInv next to an item from A it it is available in C

=IF(COUNTIF($C$1:$C$2,A1),NonInv,Inv)

 

[jeffreybrown]

Try...

=IF(COUNTIF($C$1:$C$2,A1)=0,"NonInv","Inv")

1 is a match and 0 not