make cells automatic

In A1 cell I want to put red beads in B1 cell I want put RB6MM
In A2 cell I want to put blue beads in B2 cell I want to put BB8MM

Now if in A3 I put red beads again, how can I make RB6MM come automatically in B3.

So that every time I type red beads RB6MM comes in the next cell automatically.

Hi gill1960,

welcome to the forum.

suggest you to change the thread title to reflect the query you are asking.. see forum rules:-
http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey
<click on below * if this helps>