# Return a specified answer dependent on a cell value

1. ## Return a specified answer dependent on a cell value

I have to return answer in one sheet based on the value of a cell in a seperate sheet.

=VLOOKUP(\$A:\$A,Sheet3,15,FALSE) is the column that provides a number, that when between 0 and 5 needs to return "0-5 Days", from 6 to 9 return "6-9 Days", when 10 return "10 Days", etc.

I'm sure it is a pretty simple answer that I am just way over thinking.

Please let me know if you have any questions.

2. ## Re: Return a specified answer dependent on a cell value

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

3. ## Re: 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:
`Please Login or Register  to view this content.`

4. ## Re: Return a specified answer dependent on a cell value

What about where it is =>6 and =<9, how would that work in that formula?

5. ## Re: Return a specified answer dependent on a cell value

Formula:
`Please Login or Register  to view this content.`

6. ## Re: Return a specified answer dependent on a cell value

Perfect!! Solved!

There are currently 1 users browsing this thread. (0 members and 1 guests)