| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP Novice
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Novice needing help!!! | Excel Worksheet Functions | |||
| vlookup--novice needs help consolidating! | Excel Discussion (Misc queries) | |||
| Please help! Excel Novice here | Excel Worksheet Functions | |||
| Charting help for a novice? | Charts and Charting in Excel | |||
| Novice needs help. | Excel Discussion (Misc queries) | |||
![Jeff Nelson - Lincoln College[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
