Computing the Modulus 43 Check Character

[Tojje]

Dear all,

I am working on a BarCode project and one thing I need to get is the Check Character. Its easy to get that manually but if you are looking at thousands of barcodes its essential to make that calculation in excel.

The thing is to from a given number generate a control character i.e

0=0
1=1 etc.
23=N
41=+
42=%

There are 42 different check characters in total. I want to, based on the figure in another Excel cell, get the chech character.

i.e
If I have a sum of 41 in one cell I want to get the check charater for that in another cell in this scenario it will be +

Is there a funtion in excel today to make such links based on a 42 different check characters ?
If not what would be the easiest solution ?

Many thanks for your suggestions !
Kind regards
/JE

[Tommy Bak]

Hi
make a complete list of your checkcode (like your example)

next to the cell where you produce your checkcode make a vlookup
Assuming the ckehkcode is in sheet2 A1 and the list is on sheet1 a1:b43, then in sheet2 B1 write

=VLOOKUP(A1;sheet1!a1:b43;2;FALSE)

regards Tommy

[Tommy Bak]

Hi
make a complete list of your checkcode (like your example)

next to the cell where you produce your checkcode make a vlookup
Assuming the ckehkcode is in sheet2 A1 and the list is on sheet1 a1:b43, then in sheet2 B1 write

=VLOOKUP(A1;sheet1!a1:b43;2;FALSE)

regards Tommy