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"



TIMFOX123Asked:
Who is Participating?
 
nutschConnect With a Mentor Commented:
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
 
nutschConnect With a Mentor Commented:
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
 
TIMFOX123Author Commented:
This really helps me

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

Thomas
0
All Courses

From novice to tech pro — start learning today.