vlookup data on combobox selection by formula

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

on first problem
you need to link your combobox to a cell

go into design mode and click on properties then click the combobox
find linkedcell and put a cell reference in, it can be the cell the combobox is in or some other cell

After that you can do vlookup to that linkedcell as normal formula

first example i used b3
second example i used a5
as the linkedcells

Hi,

Check the attached file. Hope this will help you.

Book1.xlsm


Regards,
Paresh J

reason pareshj's version works is he has coding beheind combobox change

Please Login or Register  to view this content.

the vlookup bit is not the major thing to consider but rather how you want the value assigned onto your spreadsheet
so you can either can do it via via linkedcell settings (which is pre) like my example or you can vba code it like pareshj (which is post)