|
|
Have a look at VLOOKUP:
http://www.contextures.com/xlFunctions02.html
tj
"gaynie" wrote:
Hi
I have a column of numbers between 0 and 150. If the value is between 2
amounts say 0 and 22 then i want it to return with a value that i set. If its
between 23 and 28 then return a different value. And so on up to 150. Is it
possible to do this?
Thanks
|