compare two columns

[tangudukiran@gmail.c]

Hi

I have two cols col A and Col B .I have to compare A col with B col and if they are equal i should put the result like 'found' in another col c. Col A has 10 elements and col B has 5 elements . suppose it the value is not found in A i should put not found. I have to put the Found and not found for all values in A col.

A B c

23 23 Found
44 44 Found
56 56
65 65
75 75
78 78
89 89
44
56
65
75
78
89
44
56
65
75
78
89
91
92
93

Regards
Kiran

[coinbank]

i am a bit confused.....

if each row is separate unto itself then the formula in column C is quite simply:

=if(a1=b1,"found","Not Found")

if you want to look at the entire A column with the contents of the b column then the formula in C is:

=if(iserror(Vlookup(a1,b$1:b$7,1,0)),"Not Found", "Found")

both formulas need to be copied down the C column

hit he scales on me and rate me