Comparing Account Numbers

[howard]

I would like to compare account numbedrs in Col B to the account numbers which I have imported into column F to see which ones have not been accounted for.

I would like a formula to enable me to do this

Your assistance in this regard with be most appreciated

 

[Yahya]

try this

Excel Workbook
	B	C	D	E	F
1	111-111	Not Found			111-115
2	111-112	Not Found			111-116
3	111-113	Not Found			111-117
4	111-114	Not Found			111-118
5	111-115	Found			111-119
6	111-116	Found			111-120
7	111-117	Found			111-121
8	111-118	Found			111-122
9	111-119	Found
10	111-120	Found
Sheet1

Excel 2007

Cell Formulas
Range	Formula
C1	=IF(ISNUMBER(MATCH(B1,$F$1:$F$8,0)),"Found","Not Found")

 

[howard]

Thanks for the help, formula works perfectly

 

[Yahya]

Thanks for the help, formula works perfectly

you are welcome