J

#### JessP27

I need to have a formula to look at two values and determine the result

based on the where the value falls in a range...

Column A

(A1) - 39,841

(A2) - 20,623

(A3) - 24,496

(A4) - 23,909

Column B

(B1) - 1,749

(B2) - 635

(B3) - 1,142

(B4) - 965

IF the number in A2 is between 38000 and 40000

OR

If the number in B2 is between 2000 and 2150

THEN "B1" should be the result in C2

IF the number in A2 is between 20000 and 37999

OR

If the number in B2 is between 1000 and 1999

THEN "B2" should be the result in C2

(I will need to repeat this pattern a couple more times as well)

I used =LOOKUP(B2,{0;10000;20000;38000},{"B4";"B3";"B2";"B1"}) to get a

result on the first set of criteria, but I just can't seem to figure out how

to get the formula to look at the second set of criteria as an OR.

Please let me know if you have any suggestions as soon as possible, as I'm

trying to get a report out yet this afternoon.

Thanks very much in advance,

Jessica