I have been a basic user for sometime,

now, have come across an issue, for which seeking the forums expertise advice.

I have a table which does a various amount of work for me, to make it simpler in the advance form of usage seek ur advice on how it can be done:

A1:Model Number B1:Model Description C1: Retail Price Per Unit
A2: 1100 B2: Nokia 1100 Mobile Phone C2: US$ 123.00

The Query i have is as follows:

Instead of Typing in the Description each time (NOKIA <Model No.> Mobile Phone); can a formula be inserted so as the cell B2 automatically changes the Model Number as and when it goes?

i.e: instead of typing Nokia 6600 Mobile Phone and thereafter?