I'm trying to create an an invoice/receipt worksheet, so that when I input a
number in a cell, the adjacent cells automatically fill using predefined
information.
For example:

If i input 1234(item no) into cell A1, I want a description to appear in
cell B1 and a Price in C1.

If anyone knows how to do this, please could you explain in Laymens terms as
Im new to all this.

Many thanks and any help is appreciated.