ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   combining data from two worksheets (https://www.excelbanter.com/excel-worksheet-functions/113582-combining-data-two-worksheets.html)

David

combining data from two worksheets
 
This is probably REALLY easy but i can't seem to figure it out. I need to
pull a user name from one worksheet adding it into another worksheet using ID
as the key. The only common data between the worksheets is the user id and
the worksheet that needs the user name is a subset of the larger master file.






Max

combining data from two worksheets
 
Try Debra's nice coverage on VLOOKUP or INDEX/MATCH at her:

http://www.contextures.com/xlFunctions02.html
VLOOKUP

http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"David" wrote:
This is probably REALLY easy but i can't seem to figure it out. I need to
pull a user name from one worksheet adding it into another worksheet using ID
as the key. The only common data between the worksheets is the user id and
the worksheet that needs the user name is a subset of the larger master file.




All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com