Thread: Help me im lost with this formula

Wanted to see if you can by any chance help me out with a problem that I ran into when I was perfecting my excel invoice form. First, I wanted to explain what exactly it is. The invoice form includes a quantity, code number for the item in the description, description/name of item, discount, cost of one unit, cost of units inputted into quantity. I have everything figured out and I think you'd be able to understand it better with the picture I made I'll also host the file on the internet for you so you can better understand the problem. Basically what happens is that when for example someone wants to input an item manually in the description nothing will happen which is good but when you input the quantity in column C, "#N/A" comes up in column D because it doesn't recognize the words in column E because of the VLOOKUP. So what I was wondering is how I would restructure my code so that the "#N/A" wouldn't show up. And one solution i thought of was if instead of finding an inequity code for the number in column C and maybe finding a logical formula for seeing if there is text in column E, but then I also have to figure out what I'm going to do with the code in column H which is also based on whatever # code is in column D. What happens in column H once it sees the code in column D it looks up the price for the item and input it into column H and if there isn't a code in there "#N/A" will come up. So, I have no clue how to fix these problems and was hoping for your insight upon this problem. And if it wasn't a bother how would I lock the cells in columns D,H,I so that when you type text into them manually the code isn't deleted. Link to a picture further explaining the contents of the form: http://img202.imageshack.us/img202/4237/picforhelp.png
Uploaded the file to maybe further show you whats wrong rapid share: http://rapidshare.com/files/29925096...Page2.xls.html

Welcome to the forum, wiL.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

In addition, if you need help with pictures, post pictures. If you need help with workbooks, ...

Thanks.

Thread closed.