Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
1st time PC builder...
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
1st time PC builder...
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Nick H
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Really appreciate some help on merging two spreadsheets...

Retrieving them now- it's very slow, for some reason.



  #6   Report Post  
Posted to microsoft.public.excel.misc
1st time PC Builder
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting links to other spreadsheets KarenH Excel Worksheet Functions 2 October 28th 05 04:09 AM
Applying Print Settings to Several Spreadsheets At Once JR_06062005 Excel Discussion (Misc queries) 1 August 3rd 05 02:47 PM
Excel Charts Linked to Spreadsheets Rich Charts and Charting in Excel 1 July 4th 05 04:36 PM
Merging Excel Spreadsheets Together LeCar Excel Discussion (Misc queries) 2 May 15th 05 06:54 PM
merging two excel spreadsheets - track changes from original Kasia Excel Worksheet Functions 0 May 6th 05 06:26 PM


All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"