Hi,

I am stuck with a problem. I need to compare two columns. one with ZIP and

other with street names. A Single ZIP has numerous streent names. Is there a

function which will say if the address is Right or Wrong?

for example:

11000 Apple Street <Right>

11000 Banana Street <Right>

11000 Mango Street <Wrong>

and so on

Thanks,

How does the function determine if it's right or wrong?

--

HTH,

Barb Reinhardt

--

HTH,

Barb Reinhardt

On Sat, 23 Aug 2008 14:00:00 -0700, shress

Try this formula in cell C1:

=IF(SUMPRODUCT((Sheet2!A$1:A$1000=A1)*(Sheet2!B$1:B$1000=B1))=0,"<Wrong>","<Right>")

Sheet2 is the name of the sheet where you put all possible ZIP codes

in column A and the correspoonding Street names in column B.

Increase the 1000 if you data takes more than 1000 rows.

Hope this helps / Lars-舓e

Try this formula in cell C1:

=IF(SUMPRODUCT((Sheet2!A$1:A$1000=A1)*(Sheet2!B$1:B$1000=B1))=0,"<Wrong>","<Right>")

Sheet2 is the name of the sheet where you put all possible ZIP codes

in column A and the correspoonding Street names in column B.

Increase the 1000 if you data takes more than 1000 rows.

Hope this helps / Lars-舓e

Hi, I have one table with valid zip/street combinations.

And I have got another bigger table which contails both valid and invalid

zip/street combinations and also lots of repetitions. I am trying to find out

those invalid addresses based on the correct table.

Thanks

1. Compare columns in two WBks and when match is found...

2. LOOKUP, MATCH MORE MATCHES IN TWO COLUMN

3. If two criteria match then sum matching values in another column

4. Comparing Two Columns on Two Worksheets and then Adding New In

5. Compare two columns in same table; result in 3 column

6. Compare one Column to a Second Column Formula Help Needed

7. compare two columns with different ranges in two worksheets

8. comparing two columns and extracting what is different into a third column

9. Compare two columns in two different workbooks

10. Macro to Compare Two Columns of Numbers on Two Sheets and Flag

11. Compare cells in column A ("ID") to column A ("ID)in two differen.

12. Compare two columns in two different workbooks

13. Comparing two columns in two different worksheets

14. COMPARE TWO COLUMNS AND GET THE VALUE IN THIRD COLUMN

15. Comparing two columns in two separate files

7 post • Page:**1** of **1**