Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Match and Sort for two range of data on different worksheets? | New Users to Excel | |||
ranking query | Excel Discussion (Misc queries) | |||
Combining data from worksheets - lookup? | Excel Discussion (Misc queries) | |||
Unique and duplicate data between 2 Excel worksheets | Excel Worksheet Functions |