I still do not understand any of that, plz can you explain in plain easy
english as I'm not very good at this sort of thing

"Tom Ogilvy" wrote:

Combine the data entered in the cell with the vlookup formula to return the
data you require.

=if(linkedcell = "","",vlookup(likedcell,table,2,False))

as an example.

Linked cell indicates the cell you have linked to the combobox and which
displays the item selected in the combobox. Table indicates a range of
cells that contain all the registration numbers in the left most column of
the range and the accompany items like make, model and engine size in
adjacent columns.

See help on Vlookup for details.

--
Regards,
Tom Ogilvy

"Addz" wrote in message
...
That didn't quite answer my question but it did clear up some issues.
(e.g.
if I have car registration numbers in the combo box, and have the rest of
the
data for the cars like make, model and engine size elsewhere in the
workbook,
I want the correct details to appear in the cells I want when I select any
one of the car registration numbers).

"Tom Ogilvy" wrote:

for a combobox from the control toolbox toolbar,
Link the combobox to the cell where you want the value to appear.

Right click on the combobox in design mode and select properties. Use
the
linked cell property with an argument like

Sheet1!B9

--
Regards,
Tom Ogilvy


"Addz" wrote in message
...
Hello

I'm trying to get some data to be synchronised with some data in a
combo
boxes, (e.g. when I select an item from the combo box I want the
correct
value/answer for it to be displayed in one of the cells).
Plz help as I'm pretty new to all of this.