compare two colums to two ther coulms????

[jbalbo]

Hi,

I have a spreadsheet with column A containing a "city" and B containing a zipcode

column C has a list of Cities and d a list of zipcodes.

I want to look at A1 and B1 and see if they match any combo in column c and d.

example

A B C D
Boston 01234 New York 20034 <- Boston would be a match
Tampa 89001 Boston 01234 <- Tampa would not be a mach not in cols C&D


Thanks In advance'
Joe

[JieJenn]

Enter this formula with Ctrl + Shift + Enter and drag it down

=IF(ISNUMBER(MATCH(C2&D2,$A$2:$A$18&$B$2:$B$18,0)),"Match", "No Match")

[NBVC]

=Isnumber(Match(1,Index(($C$2:$C$100=$A2)*($D$2:$D$100=$B2),0),0))

copied down

adjust ranges to suit.

TRUE means match found