I have a worksheet which stores item codes in column A. In column B, I have a lookup formula to display the item description. I have to prestore the formula in column B for this to work. Can the display of the item description be automated such that the item description is filled in when the user completes the entry of the item code in column A using either the Enter or the Tab key ?

Thanks in advance for any help on this