| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
| how do I merge data from separate spreadsheets | Excel Discussion (Misc queries) | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
Linear Mode
