Thanks Dave.....I'll give this a try...

"Dave Peterson" wrote:

After you get the id's into the worksheet, you could use this technique.

Create a new worksheet (call it Table) with a 3 column table.
In column A, put the student id.
In column B, put the first name.
In column C, put the last name.

Then you could use a formula like this (with the ID in A1):

=vlookup(a1,table!a:c,2,false)
(to get the first name)
=vlookup(a1,table!a:c,3,false)
(to get the last name)

Or better:
=if(a1="","",if(isna(vlookup(a1,table!a:c,2,false) ),"Missing",
vlookup(a1,table!a:c,2,false)))

(same kind of thing for the last name.

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

--

Dave Peterson