vlookup data on combobox selection by formula

[cfinch100]

hi
I have seen a few threads similar to what im asking ,have tried some but can not get my head round it,what I require is on combobox selection to bring in the data "type" from collumn ag and put it in collumn "c",i then want to get rest of data from the row but if someone has any ideas to get me started I will try and do the other data,do not know how to do formulas ,started first with userforms and would now like to learn formulas
cheers colin