excel programing

I have a simple 200 member database and want to use bar code id badges for
class check in and out.
I created the badges and now need to use the id number on the badge to
lookup 3 collums of that persons data when i scan the bar code and post it on
a new sheet.
Sounds so simple but i dont know where to start.
Help
Thank You

Look at VLOOKUP in help

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"rlenz" <u20976@uwe> wrote in message news:5ef5d28e9891e@uwe...
> I have a simple 200 member database and want to use bar code id badges
for
> class check in and out.
> I created the badges and now need to use the id number on the badge to
> lookup 3 collums of that persons data when i scan the bar code and post it
on
> a new sheet.
> Sounds so simple but i dont know where to start.
> Help
> Thank You

You could lookup a lookup.

A two-column table of badges with Badge Number and PersonID to which the badge is allocated.

A multi-column Person table for each person with (say) PersonID, Name, Other bits, Class1, Class2, Class3, Class4 etc. - thus Class1-Class3 being the 3 columns you need.

To extract your data, assume the barcode is scanned into Column A, say from cell A222 onwards, and the first table data is in C2 to D201 for your 200 badges, the second table is in F2 to M201 for your 200 employees,

Then, in B222 put
=VLOOKUP(VLOOKUP($A222,$C$2:$D$201,2,FALSE),$F$2:$M$201,COLUMN()+2,FALSE)

You can then formula drag this 2 columns rightwards, to cover the 3 data columns you require, then downwards to cover the key numbers that are allocated.

Translated the formula is:
lookup on bagde to get PersonID
lookup on that PersonID to get details from the person table, which is 7 columns from G to M

Hope this gives you some ideas, the tables can, of course, be stored on other sheets, and perhaps be Named Ranges.

--

Originally Posted by rlenz

I have a simple 200 member database and want to use bar code id badges for
class check in and out.
I created the badges and now need to use the id number on the badge to
lookup 3 collums of that persons data when i scan the bar code and post it on
a new sheet.
Sounds so simple but i dont know where to start.
Help
Thank You