Data from 2 spreadsheets
 

Hello, quick question. I have 1 spreadsheet containing all the users in the
company and a second spreadsheet containing only those with e-mail. However
spreadsheet 1 has a column that spreadsheet 2 does not have and needs to. The
only problem is the column I need contains values that are specific to the
user. How do I go about copying this column to spreadsheet2?

Data from 2 spreadsheets
 

Hi John

Insert a column with VLookup formulas in workbook 2 that look
if the user exist in the workbook 1 and display the column value

See Debra's site if you never used a VLookup formula
http://www.contextures.com/xlFunctions02.html



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"John" wrote in message ...
Hello, quick question. I have 1 spreadsheet containing all the users in the
company and a second spreadsheet containing only those with e-mail. However
spreadsheet 1 has a column that spreadsheet 2 does not have and needs to. The
only problem is the column I need contains values that are specific to the
user. How do I go about copying this column to spreadsheet2?

Data from 2 spreadsheets
 

Your formula looks like this then

A1 = the lookup value
look in [Book2.xlsx]Sheet1'!$A$1:$B$100
Display the second column (,2)

=VLOOKUP(A1,'C:\Users\Ron\Documents\[Book2.xlsx]Sheet1'!$A$1:$B$100,2)

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
Hi John

Insert a column with VLookup formulas in workbook 2 that look
if the user exist in the workbook 1 and display the column value

See Debra's site if you never used a VLookup formula
http://www.contextures.com/xlFunctions02.html



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"John" wrote in message ...
Hello, quick question. I have 1 spreadsheet containing all the users in the
company and a second spreadsheet containing only those with e-mail. However
spreadsheet 1 has a column that spreadsheet 2 does not have and needs to. The
only problem is the column I need contains values that are specific to the
user. How do I go about copying this column to spreadsheet2?