Thread: Need Help ASAP - Comparing Multiple Columns

Okay there are two tables. Table 1 has Street, City, State, Zip, and Building Number. Table 2 has Street, City, State, and Zip. Is there anyway in excel to compare the street information and if its correct, return the Building number on the other table.

So if Table 1 (Column A,B,C,D) = Table 2 (A,B,C,D) - Return Column D from Table 1 onto Column E in Table 2.

I hope someone can help. Thanks.

Yes several options depending on if the number is always a number

if table 1 in b2:e30 and table 2 in h2:j10

if yes in k2

=sumproduct((b2:b30=h2)*(c2:c30=i2)*(d2:d30=j2)*(e2:e30))

or in a2 put =b2&c2&d2 and copy it down

in k2 put (vlookup(h2&i2&j2,a2:e30,5,false)

There are other more elegant ways but they are functional

Regards

Dav

Im not sure what all that means

Why not post an example as a zipped file

Regards

Dav

Why not post an example as a zipped file

Regards

Dav