Compare values

[krysty]

Hello mister
I try to explain first in my language , else in yours
Incerc sa compar grupuri de valori adica de exemplu in coloana A si B am valorile corecte de exemplu in A1-"Bucuresti" (town) B1-"100" (postal code), A2-"Suceava" si B2-"101, etc
In E1 am "Bucuresti" si F1-"102" . Compar e1+f1 cu toate valorile depe coloanele A+B si formula returneaza eroare.
In E2-"Suceava" si F2-"101" return True
E3-"Bacau" si F3-"100" return False
Care e formula?
pentru comparare a doua siruri am gasit formula {or(exact(.....)} array formula.
Dar pentru grupuri de two parameters? Use range or something else? Mersi anyway. Cristi

 

[Greg Truby]

<TABLE border=1 cellSpacing=0 borderColor=#c0c0c0 borderColorDark=#ffffff><TR><TH style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63>City</TH><TH style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=87>Postal Code</TH><TH style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TH><TH style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TH><TH style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=74>City</TH><TH style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=109>Postal Code</TH><TH style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63>Match?</TH></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63>Bucharest</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=87 align=right>100</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=74>Bucharest</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=109 align=right>102</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>FALSE</TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63>Suceava</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=87 align=right>101</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=74>Suceava</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=109 align=right>101</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>TRUE</TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63>Bacau</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=87 align=right>102</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=74>Bacau</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=109 align=right>100</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>FALSE</TD></TR></TABLE>

<!-- Please do not remove this header --><!-- Table easily created from Excel with ASAP Utilities (http://www.asap-utilities.com) --><TABLE border=1 cellSpacing=0 borderColor=#c0c0c0 borderColorDark=#ffffff><TR><TH style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63>City</TH><TH style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=87>Postal Code</TH><TH style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TH><TH style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TH><TH style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=74>City</TH><TH style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=109>Postal Code</TH><TH style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63>Match?</TH></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63>Bucharest</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=87 align=right>100</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=74>Bucharest</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=109 align=right>102</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>=VLOOKUP(E2,$A$2:$B$4,2,FALSE) = F2</TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63>Suceava</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=87 align=right>101</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=74>Suceava</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=109 align=right>101</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>=VLOOKUP(E3,$A$2:$B$4,2,FALSE) = F3</TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63>Bacau</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=87 align=right>102</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=74>Bacau</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=109 align=right>100</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>=VLOOKUP(E4,$A$2:$B$4,2,FALSE) = F4</TD></TR></TABLE>

Excel Workbook
	A	B	C	D	E	F	G
1	City	Postal Code			City	Postal Code	Match?
2	Bucharest	100			Bucharest	102	FALSE
3	Suceava	101			Suceava	101	TRUE
4	Bacau	102			Bacau	100	FALSE
Sheet1

 

[krysty]

Thank you
But i have other problems.
First if the first value (town) is blanck (nothing in cell) i get the #N/A.
If the second of those two (postal code) is blanck I dont get #N/A.
For code postal like 0127, first is a zero, type of data should be text or general. Are problems when you compare data?
It is possible instead of answer FALSE to know exactly which value ( town or postal code ) is wrong. I will manage o entire shett of data
Could you extand the formula for three or four parameters? Let's say i have another one for type of town (2 for capital, 1 for big town (population less 1 milion, 0 for other town) -- 2 Buckarest 101.
Its nice when you answer me Mersi again.