Match text in two columns, report matches

[BobKarrow]

I’m trying to compare two columns (of text) to see if there are any matches. Column A has 21 items, Column B has 1259 items. I came up with
=IF(($A$1:$A$33)=B1),"MATCH","no"
but that contains an error (if not several).
I'd like column C to report "no" or "Match".
Can anyone help me?

 

[Fluff]

Thanks for that. This is what I get with that data which looks right, unless I have misunderstood what you want.

+Fluff 1.xlsm
	A	B	C
1
2	Breaking of the Circle Studies on the Effect of the "New Science" Upon Seventeenth Century Poetry	"Royal" Road Book of England	No
3	Consumption of Culture 1600-1800	Malta in British and French Caricature 1798-1815	Match
4	History of Popular Culture to 1815	Spirit Pond Runestones	No
5	Holy Delight: Typology, Numerology & Autobiography in Donne's Devotions Upon Emergent Occasions	Wisconsin Land and Life	No
6	Hymns and Spiritual Songs	Consumption of Culture 1600-1800	No
7	Introduction of Arabic Learning into England; The Panizzi Lectures 1996	Reading, Ordnance Survey: Sheet SU 67/77	No
8	John Donne, A Literary Life	Ticket and Sign Writing	No
9	Literary Theory	Universale Novo	No
10	Lure of Antiquity and the Cult of the Machine	History of Astronomy	No
11	Madison, A Model City	Birth & Development of the Geological Sciences	No
12	Mahogany Ship, Relic or Legend?	Little Book of Map Projection	No
13	Malta in British and French Caricature 1798-1815	Oxford in 1578	Match
14	Maze of Ingenuity : ideas and idealism in the development of technology	Wisconsin Survey Bulletin 71 Geology of Gogebic Iron Range of WI	No
15	Mythologies	Changing Image of the City	No
16	Perspective of the World	Pedro Reinel Me Fez	No
17	Pope, His Banker & Venice	Sud Italia da Roma a Messina	No
18	Power/Knowledge	Priciples of Navigation	No
19	Prints as Propaganda. The German Reformation	Printed Image and the Transformation of Popular Culture 1790 -1860	No
20	Quiddities : an Intermittently Philosophical Dictionary	Poem "Do not stand at my grave and weep"	No
21	Redding 1540 -1640; A Portrait of a Community	What a Wonderful World Catalogue 105	No
22	Romance of Wisconsin Place Names	Visio Mundi	No
23	Science and Society	Museo Communale di Gubbio-Incisioni	No
24	Science of Measurement	Statistiken als Grundlage wirtschaftskartographischer Arbeiten Festchrift Leopold G. Scheidl zum 60 Geurtstag	No
25	Settlers of Dane County	Thematische Kartographie: Graphik - Konzeption - Technik	No
26	Sickness and Health in America	Dynamics of Architectural Form	No
27	Social History of Truth	New Essays on the Psychology of Art	No
28	Spirit Pond Runestones	Visual Thinking	Match
29	Studi in Memoria di Teofilo Ossian De Negri [Genoese historian]	Eton Comparative Atlas of Ancient & Modern Geography	No
30	University College of Swansea, an Illustrated History	Karttu Production Model of the Basic Map	No
31	Varieties of Cultural History	Le Arti e i Mestieri di Firenze	No
32	Watts Divine Songs for the Use of Children	Clock We Live On	No
33	Welsh Hills - Waukesha	J. B.	No
34	Wisconsin Land and Life	R. H. M. Robert Hunter Middleton, Memorial Service	Match
35		Manhattan in Maps 1556 - 1990
36		Some Sixteenth Century Watermarks Found in Maps Prevalent in the IATO Atlases
Compare

Cell Formulas
Range	Formula
C2:C34	C2	=IF(ISNA(MATCH(A2,$B$2:$B$1292,0)),"No","Match")

 

[BobKarrow]

Well, it looks right, in the sense that B3:B6 are the four titles in B2:B36 that match titles in A2:A34, but how did that happen? Because column C shows four "Matches" but only one of them is really a match: B3=A13, but C4:C6 all say "no."

 

[Fluff]

It's matching the value in col A against col B so col C has match where that value in A was found in B.
Are you wanting it to go the other way?

 

[BobKarrow]

But C13 says Match but B13 ("Oxford in 1578") is NOT found in A. In other words, with just the truncated selection in B (35 out of 1259 lines) I want to see MATCH in C3:C6. That way I can sort all 1259 lines by column C to find the entries that match. I will put other values in column A and try to find matches for THEM.

 

[Fluff]

C13 says Match as A13 is found in col B.
If you want it the other way round use

=IF(ISNA(MATCH(B2,$A$2:$A$50,0)),"No","Match")

 

[BobKarrow]

C13 says Match as A13 is found in col B.
If you want it the other way round use

=IF(ISNA(MATCH(B2,$A$2:$A$50,0)),"No","Match")

BINGO! That is exactly what I want. Thanks very much, Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.