sorting and combining data

G

Guest

I've got two different spread sheets with large amount of
data. These two charts however share one grout of data
(in this case street address) The first set of data
(worksheet) doesn't have the phone numbers and the 2nd
worksheet does have the phone numbers. I want excel to
combine a worksheet let say three that will conbine
worksheet 1 and 2 so we have worksheet 3 with
phonenumbers address and all the other info.
 
B

Bernie Deitrick

Matt,

Insert a column into your table, and use a VLOOKUP function to match
the address in the other table and return the phone number.

If your addresses are in column B in both sheets, and the phone
numbers are in column D in the table on Sheet2, then in Sheet1, insert
a column and use the formula

=VLOOKUP(B1,Sheet2!B:D,3,FALSE)

HTH,
Bernie
 
Top