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.

While I am sure you will want to handle more value ranges, here is a formula
to do exactly what you asked.

=IF(AND(A1=1,A1<=15),575,IF(AND(A1=90,A1<=105),6 25,"??"))

Put this formula in B1 and then copy it down to the end of your data.

Rick