If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
barcoding
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. |
#2
|
|||
|
|||
barcoding
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 "Kevin" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|