If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sorting and combining data
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. |
#2
|
|||
|
|||
sorting and combining data
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,3,FALSE) HTH, Bernie wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|