Really appreciate some help on merging two spreadsheets...

  • Thread starter 1st time PC builder...
  • Start date
1

1st time PC builder...

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.
 
D

Dave O

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.
 
1

1st time PC builder...

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.
 
N

Nick H

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
 
Top