I have a drop down list of different products that I sell and I want to be able to click on one of those products in the drop down list and then in the cost column of my spreadsheet I want it to insert the price for that product from the drop down list. ANy help on how to do this would be great, I trie V Lookup and IF then statments and I can't get them to work.


Thanks Scott