barcoding

[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.

 

[L. Howard Kittle]

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