excel programing

[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

 

[Bob Phillips]

Look at VLOOKUP in help

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Bryan Hessey]

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.

--