Sure, assuming the id drops into, say, A2, in B2, type
=VLOOKUP(A2,StudentList!A:C,3,0)&", "&VLOOKUP(A2,StudentList!A:C,2,0)

This will show last, first into cell B2.

Copy the formula down your rows.

This assumes your data is on a tab named StudentList and is in columns A
through C.

"Jeff Nelson - Lincoln College" wrote:

I'm not even sure if VLOOKUP is what I want to use, but here goes:

We are importing a list of Student ID's, First Names, and Last Names into
Excel. Then, as students show their student ID, the barcode scanner will scan
their Student ID into the system.

We would like it to display the student first name and last name next to the
Student ID number when the ID is scanned.

For example, student shows his ID. Attendance scans the ID with his
hand-held barcode scanner. The ID number (#423423) then displays on the
screen. We would like the student name to appear right along side the ID

<Scan ID#: 423423 Simpson, Stan

Any ideas?

Thanks,
Jeff

Office 2007 Product