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.

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.

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

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

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

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