I am using a combo box to select a value from a table in another worksheet to populate a cell which is working fine. However, I want to use values from this same selection row to populate another two or three cells.

Say.... from the drop down list of the combo box I select value G and on the same row as this value are H,I, and J. I also want to copy these values to specific cells in my excel sheet.

Can this be done? How do I do it? I would be grateful to anyone who can help me out with this question.