barcoding

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Please help.
I have added a font to windows to barcode documents. This
font requires an asterisk before and after the value to be
scanned. The value I am scanning is looked up from a
differnet sheet and changes at the users discretion. Can
I add something to the formula that will add the asterisk
both before and after the value?
Thanks in advance.
 
Hi Keven,

Don't know how your data is set up but something like this might get you
going.

="*"&VLOOKUP(C1,Sheet2!A1:B10,2,0)&"*"

Where C1 is a lookup value, the table is on sheet 2 A1:b10 etc.

Returns something like *114* in my little test.

HTH
Regards,
Howard
 
Back
Top