Hi everyone, I am new to the forum and excel so first off, I wanted to apologize for any errors that may occur.
I am trying to get a price to show up in cell after picking product from dropdown list. The product and price table are in another sheet and are seperated product price - product price, and I don´t know VBA at all if that is necessary.
The example of the Invoice sheet1 product table sheet2:
Sheet1
A------------------------------------------B-----------------------------------------------------------C
Product Tipe--------------------------Product--------------------------------------------------------Price
Diverse----------------------------------Washer--------------------------------------------------------0,30
Sheet2
A-----------B---------------C------------D----------------E--------------F----------G----------------H
Diverse----Price--------Steel-------Price-----------Aluminum--------price-------Nickel-------------Price
washer---------0,30---------1/2--------2.00------------1/4 pipe---------7.00--------sheet-------------2.00
Hope someone can help.
Thanks
Bookmarks