Formula that returns values based on criteria

I am trying to create a table that returns values based on a set of criteria. A is a formula that generates a numeric value. The criteria are as follows:
If A<1, return -4
If 1<A<2, return -3
If 2<A<3, return 1
If 3<A, return 4

I then want to use this table and, based on the value of A, return the correct value. I am having difficulty for the values that are less than 1 and greater than 3. Any ideas on how to setup a table or generate the values that I would like without doing a long nested if?

Thank you!

Originally Posted by jeffreybrown

How about...

=LOOKUP(A1,{0,1,2,3},{-4,-3,1,4})

Jeff - this works perfectly except for values below 0. What do you recommend for negative values?

Originally Posted by jeffreybrown

What do you want for a value below 0?

If you don't want anything for a negative number...

=IF(A1<0,"",LOOKUP(A1,{0,1,2,3},{-4,-3,1,4}))

Thanks, Jeff. Got it!