Invoice product code gone awry

[baconandeggs]

Hello all

Especially Dreamboat

I have a .xls file wih an invoice which accepts the product codes (from the underlying worksheet), and fills in the next line on the invioce with the whole product name, but for some reason, it now only seems to pick up the first similar product

Any help is greatly appreciated


Jim

 

[Dreamboat]

Jim, sounds like the formulas got re/over written. If you want to email it back, feel free. Otherwise, you can try this:

I'm assuming I put a bunch of IF's and stuff in there, but the part we're concerned about is the vlookup part. If it says, for instance:

IF.....vlookup(cell,range,3)

or if it says:

IF.....vlookup(cell,range,3,1)

Change it to:

IF.....vlookup(cell,range,3,0)

Either that, or your products are out of alphabetical order, and you may need just to sort them again. I don't remember all the specifics of your worksheet.

http://www.TheWordExpert.com

 

[Dreamboat]

Sorry--didn't finish.

Basically, that added zero is what we're looking for. It means don't find a close match, find an exact match.

http://www.TheWordExpert.com

 

[baconandeggs]

Dreamboat

Thanks for your fast response, will this code only work in alphabetic order, as opposed to numeric or alpha numeric

Bestregards

jim

 

[Dreamboat]

I don't remember, Jim. Can you email the file??

http://www.TheWordExpert.com

 

[baconandeggs]

Thanks for your help Dreamboat, I had difficulty E-mailing you twice, but I donT want to bother you too much, I can get by with what you hacve shown me, I really want to make the product codes numerical so with the long weekend upon us I will have a go

best regards


jim

 

[Dreamboat]

Dreamboat@TheWordExpert.com

It may have changed from what you have, Jim.

http://www.TheWordExpert.com

 

[baconandeggs]

Dreamboat

Is there a program that will assign a sequential number to an invoice form


Best regards

Jim