vlookup returning same value

[dixonma]

So I am trying to do a vlookup stating if tickets are under 30 days old, 30-59 days, 60-89 days, over 90 days old. Due to the source of where we have to pull data from I have had to create a "Days Aged" formula to base this off of =DAYS360(C9,C10) (Column C is my Date created). All my my results are coming back >90? Even the tickets that are only 12 days old. Vlook up table pic below. Formula is =VLOOKUP("[@[Days Aged]]",$A$2:$C$5,3,TRUE). PLEASE HELP I have searched forums for days for answers! Is it because my vlookup is based on another formula? Is there a better formula to use?

Category Min (>=)	Category Max (<)	Catergory Name
"0"	"-29"	<30
"-30"	"-59"	31-60
"-60"	"-89"	61-90
"-90"	"-1000"	>90
Days Aged	Ticketid	Datecreated	30/60/90
		8/1/2017
-357	17653	08/04/2016 04:21 PM	>90

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[mgrady11]

Your VLookup formula is correct, however what you are trying to do will not work with a VLookup. Within the VLookup formula, the "3", indicates that the formula will only look at what is in the 3rd column, so you will most likely only receive the same answer.

Source for VLookup formula: Excel VLOOKUP Function

Solution: Try using IF Formula Excel IF Function
See formula below(might be missing parenthesis)

=if("[@[Days Aged]]"<30,"<30",if(and("[@[Days Aged]]">=31,"[@[Days Aged]]"<30),"31-60",if(and("[@[Days Aged]]">=61,"[@[Days Aged]]<90),"61-90",">90")))

 

[dixonma]

Thanks mgrady11.

I am getting an error with that if formula. I will work with it.

 

[dixonma]

Finally got this resolved. I had to multiple my negative values by -1 to give me positive values. Then I used the nested if function below. Hope this helps someone else.
=IF(AND(B10>0,B10<30),30,IF(AND(B10>29,B10<60),60,IF(AND(B10>59,B10<90),90,IF(B10>89,90,0))))