if then or vlook up

Yes, build a lookup table and use VLOOKUP.

Technically you can nest 64 IF's in XL2010 I think, but that wouldn't be fun to write.

Build a table and use VLOOKUP is your best option. If you really don't want to make a table you can write a table into a named range,

This saved as a Named Range (Formulas tab, Name manager)
={100,"Apple";200,"Orange";300,"Banana";400,"Grape";500,"OPTIMUSPRIME"}
When you reference the named range it will be looking at something like this:

100	Apple
200	Orange
300	Banana
400	Grape
500	OPTIMUSPRIME

So if you made the above a named range called "fruit", the vlookup would look like
=VLOOKUP(A1,fruit,2,1)

If A1 is 1, it will return Apple
if A1 is 10, it will return Apple
if A1 is 101, it will return Orange
if A1 is 99999, it will return OPTIMUSPRIME



EDIT
On second thoughts, this is easier

Change as needed


=LOOKUP(N(RIGHT(A6,3)),{0,100,200,300,400},{"One","Two","Three","Four","Five"})

0-99 = "One"
100-199 = "Two"

And so on.

Boogieman,

Please don't hijack threads, it's against the rules.

Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.