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.

Put this in B3 and drag down as required:-

=IF(AND(A3=1,A3<=A$1),575,IF(AND(A3=A$2,A3<=105) ,625,"Unspecified"))

because you don't sat what happens for other values in ColA it will return
Unspecified.

Mike

"Richard" wrote:

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.

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