Is there a way that I can have Excel assign a value in one column based on
the value in another column. For example A1 has a value of 15 and A2 has a
value of 90. I would like Excel to recognize that anything in the A column
with a value of 1 to 15 should have a B column value of 575 and any A column
value between 90 and 105 should have a value of 625.

I hope that makes sense. I'm not sure if I need to set up an array or if a
simple formula would suffice. Ideas appreciated to avoid typing out every
possible value of column A and associated column B value in a seperate
worksheet.