Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Really appreciate some help on merging two spreadsheets...
Hi All,
I have two spreadsheets - one of them has a list of addresses and bandwidth requirements per site for a VPN. The other sheet has the same addresses in a different order with postcodes. I need to merge them together so I have one sheet which has both the bandwidth and the postcodes - is there any easy way to do this? Appreciate your help in advance. Rob. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Really appreciate some help on merging two spreadsheets...
Yes: check out VLOOKUP in Help. It will look up an item in a range and
return another cell from within that range. Note, however, that the spelling of site names or whatever your lookup value is must match exactly. Please post examples of your data if you get stuck. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Really appreciate some help on merging two spreadsheets...
Dave, thanks so much for your response - stuck in the middle of nowhere in
the UK at the moment with no heating so would be good to sort this!! I have sent the sheets to your yahoo.com email address - hope you don't mind. "Dave O" wrote: Yes: check out VLOOKUP in Help. It will look up an item in a range and return another cell from within that range. Note, however, that the spelling of site names or whatever your lookup value is must match exactly. Please post examples of your data if you get stuck. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Really appreciate some help on merging two spreadsheets...
Hi Rob,
Is each address a single string or is it broken down into discrete fields? E.g. Street, Town, County, Post Code. If the latter, you will probably be able to accomplish what you need using VLOOKUP. Otherwise you will need to parse the strings first to get some matching fields between the two spreadsheets. Nick |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Really appreciate some help on merging two spreadsheets...
Retrieving them now- it's very slow, for some reason.
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Really appreciate some help on merging two spreadsheets...
Nick - you have mail!
"Nick H" wrote: Hi Rob, Is each address a single string or is it broken down into discrete fields? E.g. Street, Town, County, Post Code. If the latter, you will probably be able to accomplish what you need using VLOOKUP. Otherwise you will need to parse the strings first to get some matching fields between the two spreadsheets. Nick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting links to other spreadsheets | Excel Worksheet Functions | |||
Applying Print Settings to Several Spreadsheets At Once | Excel Discussion (Misc queries) | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
Merging Excel Spreadsheets Together | Excel Discussion (Misc queries) | |||
merging two excel spreadsheets - track changes from original | Excel Worksheet Functions |