combining data from two worksheets

[David]

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]

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