Dear All,

Please, I need your expert help to decide whether to use a VBA code or a VLOOKUP formula for a lookup.

I have used the ActiveX Control to create two comboboxes. Combobox2 is dependent on Combobox1. I wish to use this setup for a quick look-up of the price of products. Combobox1 is in Cell D5, Box2 is in Cell D6, and the output Cell for the Price is Cell D7.

The issue is that I wish to know which of the two - a VBA code or A VLOOKUP formula - would be best for Cell D7 (i.e. the cell that outputs the Price). I should be grateful for your advice. I would like to go with the option that will be problem-free, easier to work with, and therefore better between the two.

Thanks all for your help.

Newqueen