I have two work sheet set up, one is for invoice and second for Products. On
products worksheet I have column A11 to A100 with product code, C11 to C100
with description, F11 to F100 List price, so on. On invoice sheet I try to
set up like column A 11 to A 100 for product code were type code in and it'll
put data informtion from product worksheet on invoice for description, list
price and ect. I keep getting errors trying to set this up, any solution?

Addition : Define range A2:Annn in Product sheet as Productcodearea

Plus the suggestions in my previous reply

"Curtis" wrote:

I have two work sheet set up, one is for invoice and second for Products. On
products worksheet I have column A11 to A100 with product code, C11 to C100
with description, F11 to F100 List price, so on. On invoice sheet I try to
set up like column A 11 to A 100 for product code were type code in and it'll
put data informtion from product worksheet on invoice for description, list
price and ect. I keep getting errors trying to set this up, any solution?