compare contents of two adjacent columns
 

Hi,

I have two columns of text that I want to compare.

I need to see whether any of the values in column A are missing from column B.

EG:

A B C

ab4 ah6 no match
ab5 zqv no match
abs abs match
abv abv match

Hopefully it can give something like Column C as the result.

I have tried IF statements & functions such as Exact but cant get it to work.

Any help will be very much appreciated.

Many Thanks.

=IF(A1=B1,"match","no match")

and then copy down column C
--
Gary's Student


"Adam" wrote:

Hi,

I have two columns of text that I want to compare.

I need to see whether any of the values in column A are missing from column B.

EG:

A B C

ab4 ah6 no match
ab5 zqv no match
abs abs match
abv abv match

Hopefully it can give something like Column C as the result.

I have tried IF statements & functions such as Exact but cant get it to work.

Any help will be very much appreciated.

Many Thanks.

"?B?QWRhbQ==?=" wrote in
:

I need to see whether any of the values in column A are missing from
column B.

EG:

A B C

ab4 ah6 no match
ab5 zqv no match
abs abs match
abv abv match


Pity it isn't your B-column that is sorted. You could then have used the
vlookup function.
Perhaps you can copy the B-column values to a different column, sort it
there and then do the lookup?


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)

Thanks Gary, but I need to compare values in the whole of column B to the
specific ones in column A.

Eg Compare Cell A1 to any value in the whole of column B.

"Gary's Student" wrote:

=IF(A1=B1,"match","no match")

and then copy down column C
--
Gary's Student


"Adam" wrote:

Hi,

I have two columns of text that I want to compare.

I need to see whether any of the values in column A are missing from column B.

EG:

A B C

ab4 ah6 no match
ab5 zqv no match
abs abs match
abv abv match

Hopefully it can give something like Column C as the result.

I have tried IF statements & functions such as Exact but cant get it to work.

Any help will be very much appreciated.

Many Thanks.

Thanks Dodo,

Yes I could sort column B, if I did how would I construct the lookup bearing
in mind I need to match specific values in column A to any in B ?

"Dodo" wrote:

"?B?QWRhbQ==?=" wrote in
:

I need to see whether any of the values in column A are missing from
column B.

EG:

A B C

ab4 ah6 no match
ab5 zqv no match
abs abs match
abv abv match


Pity it isn't your B-column that is sorted. You could then have used the
vlookup function.
Perhaps you can copy the B-column values to a different column, sort it
there and then do the lookup?


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)

"?B?QWRhbQ==?=" wrote in
:

Thanks Dodo,

Yes I could sort column B, if I did how would I construct the lookup
bearing in mind I need to match specific values in column A to any in
B ?


I'm supposing Row1 contains labels. Then in cell C2 I would put:

=IF(ISERROR(VLOOKUP(A2;B2:B5;1));"No match";"Match")

Copy this formula down column C.


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)

Dodo wrote in
:

"?B?QWRhbQ==?=" wrote in
:

Thanks Dodo,

Yes I could sort column B, if I did how would I construct the lookup
bearing in mind I need to match specific values in column A to any in
B ?


I'm supposing Row1 contains labels. Then in cell C2 I would put:

=IF(ISERROR(VLOOKUP(A2;B2:B5;1));"No match";"Match")

Copy this formula down column C.



Oops, forgot to fix the lookup range!

So, make the formula:

=IF(ISERROR(VLOOKUP(A2;$B$2:$B$5;1));"No match";"Match")

And set the range to the range you actually have before you copy the
formula down.

--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)