Need help solving problem doing vlookup
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? |
Need help solving problem doing vlookup
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? |
All times are GMT +1. The time now is 05:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com