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.
Bookmarks