Hi. I’m a newbie I’m afraid and this is probably really basic stuff for you guys. I simply want to input a number in a cell which corresponds to a number in a list on another worksheet. I want excel to fill in the rest of the row from that list for me. For example if the list is column A product ref, B product, and C product price, i would like excel to fill in the row if i only fill in column A.
Hope someone can help
