Excel Formula

Please help. I went to an Excel Seminar and came away with one question answered. I need to know how: If I type text in one field the text that “matches” it “pop” into the appropriate fields in the same line.
example:
1 2
Womens Group (I type) STC08 (automatic)
I am an Excel newB.