Originally Posted by tupham

VLOOKUP is the best way to handle this. I have attached a sample worksheet.

To use VLOOKUP you need a table that contains the fixed values. This table is then referenced to generate your data in column B.

This function can be difficult to understand so it's worth spending some time reading Excel's help and playing around with the samples it provides.