Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • Last Modified:

How do I combine two spreadsheets with 1000+ lines ?

I have two spreadsheets with one thousand lines.

Each has a server name on the left hand side.  

I want to make them just one spreadsheet with the server name on the left hand side.

In database terms, I want to do a 1 to 1 relatoinship on a primary key named "server name"



0
TIMFOX123
Asked:
TIMFOX123
  • 3
2 Solutions
 
nutschCommented:
if it's a 1 to 1 relationship, use a vlookup formula on one of the sheets, referencing the other, eg in sheet1, assuming you put the formula in column L, use:
=vlookup(a2,sheet2!$A$1:$Z$1000,column()-column($L2)+2,0)

then copy to the right as far as you have columns in sheet2 and copy down for as many rows as you have in sheet1.

T
0
 
nutschCommented:
this assumes:
your server name is in column A,

sheet2 has data on the range a1:z1000,

sheet2 is called sheet2,
you put the formula in column L.

Thomas

0
 
TIMFOX123Author Commented:
This really helps me

thx
0
 
nutschCommented:
Glad to help. Thanks for the grade.

Thomas
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now