Vlookup

[simont123]

Hi, I am very new to Excel so please anyone kind enough to answer can you keep it very basic.

I have two columns of data, one with a product identifier code and the next with the price for that product. All I want to do is have a pull down list (combo box maybe) - when I select the product identifier from this list I would like the price that matches to be inserted into another box nearby.

This way when we take an order we can quickly select the product and get a value to add up with.

Any help really appreciated

Simon

 

[Juan Pablo González]

This is the 'International forum', where all NON-English question should be posted... and I see you already put the same question in 'Excel questions', so, locking this one.

http://www.mrexcel.com/board2/viewtopic.php?t=68320