A
aidoneus
Sorry if this has an easy answer, but I've been wracking my brain trying
to figure out how to do this and have thusfar come up empty.
I've got a workbook that on the first sheet takes ID number data in
from a card reader, formats it, and time-stamps it (it's to keep track
of the users of a supply area).
On the second sheet (same book), I've got a listing of ID numbers,
names, and departments for all the users of this room (there are over
1000).
What I'm trying to do is have a cell on the first sheet look up the
name associated with an ID number and put that information in a cell,
and do the same for department.
Something like this:
Sheet one contains:
- ID Number (which is input from the card reader)
- Time In
Sheet two contains:
- ID Number
- Name
- Department
I'd like those last two fields to propagate to the first sheet based
upon the ID number input.
Any idea how I can do this? Thanks!
to figure out how to do this and have thusfar come up empty.
I've got a workbook that on the first sheet takes ID number data in
from a card reader, formats it, and time-stamps it (it's to keep track
of the users of a supply area).
On the second sheet (same book), I've got a listing of ID numbers,
names, and departments for all the users of this room (there are over
1000).
What I'm trying to do is have a cell on the first sheet look up the
name associated with an ID number and put that information in a cell,
and do the same for department.
Something like this:
Sheet one contains:
- ID Number (which is input from the card reader)
- Time In
Sheet two contains:
- ID Number
- Name
- Department
I'd like those last two fields to propagate to the first sheet based
upon the ID number input.
Any idea how I can do this? Thanks!