Return a specified answer dependent on a cell value

Originally Posted by major88

Sorry this should be in the excel funtions and formulas forum. How do I get it moved there?

I'll do it for you!

In the meantime try something like this.

Formula:

=if(and(VLOOKUP($A:$A,Sheet3,15,FALSE)>=0,VLOOKUP($A:$A,Sheet3,15,FALSE)<=5,"0-5 Days",if(and...