![]() |
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. |
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