Here is what I am trying to accomplish...

I am creating a spreadsheet that when I type the product series in cell A1, it will automatically know to enter the corresponding catalog # into cell B1. I will be doing this for hundreds of product series.

For Example:

If I type AEP into cell A1, the worksheet will automatically enter #123 into cell B1,

If I type DEB into cell A2, the worksheet will automatically enter #458 into cell B2,

and so on...


I understand that I will have to create a master list with what series goes with each catalog #, but I am not to sure where to go from there???

Please Help..............thanks in advance