sorting and combining data

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
Back
Top