assinging text to value ranges

[tkollo1984]

Hi

What I want to do is to assign text to values based on ranges. Something like this


z<-2 +++
z>-2 and z<-1 ++
z>-1 and z<-0,25 +
z>-0,25 and z<0,25 0
z>0,25 and z<1 -
z>1 and z<2 - -
z>2 - - -

So if the value in a cell is 1.45 for example than it would be "- -" and so on. I did these kind of things with nested if functions before, but I can't really do it with this many and I was wondering if there is an easier way to do this.

Hope I was clear enough. I am welcoming any suggestions.

Cheers

[MarvinP]

Hi tkollo1984

You need a VLookup with a Range_Lookup value of True. See the Example attached.