Multiple IF/VLOOKUP String (Excel Example Attached)

[DigitalData]

All,

I want to thank you in advance for helping me. I just need help creating a custom IF/VLOOKUP string based off of a list table. I will attach the file for an example. It should be pretty straightforward. Once I get past 3 or so IFs combined it starts getting choppy for me. I really do appreciate the help and people taking their own time to help others on here.

Column A = Hire Date
Column B = Term Date
Column C = Employment Length (formula for Term Date - Hire Date)
Column D = MIN DAYS
Column E = MAX DAYS
Column F = Criteria needs to fit

So I need one formula for column to see to check if it fits ANY of the criteras from column 5. Which one is it basically.

[TABLE="width: 1168"]
<tbody>[TR]
[TD]Hire Date[/TD]
[TD]Term Date[/TD]
[TD]Employment Length[/TD]
[TD]MINIMUM DAYS[/TD]
[TD]MAXIMUM DAYS[/TD]
[TD]TENURE TYPE[/TD]
[/TR]
[TR]
[TD]6/1/2018[/TD]
[TD]6/2/2018[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]2.99[/TD]
[TD]1) 0-2 Days[/TD]
[/TR]
[TR]
[TD]5/30/2018[/TD]
[TD]6/2/2018[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]7.99[/TD]
[TD]2) 3-7 Days[/TD]
[/TR]
[TR]
[TD]5/15/2018[/TD]
[TD]6/2/2018[/TD]
[TD]18[/TD]
[TD]8[/TD]
[TD]30[/TD]
[TD]3) 8-30 Days[/TD]
[/TR]
[TR]
[TD]5/1/2018[/TD]
[TD]6/2/2018[/TD]
[TD]32[/TD]
[TD]30.01[/TD]
[TD]60[/TD]
[TD]4) 30-60 Days[/TD]
[/TR]
[TR]
[TD]4/1/2018[/TD]
[TD]6/2/2018[/TD]
[TD]62[/TD]
[TD]60.01[/TD]
[TD]90[/TD]
[TD]5) 60-90 Days[/TD]
[/TR]
[TR]
[TD]3/1/2018[/TD]
[TD]6/2/2018[/TD]
[TD]93[/TD]
[TD]90.01[/TD]
[TD]180[/TD]
[TD]6) 90-180 Days[/TD]
[/TR]
[TR]
[TD]1/1/2017[/TD]
[TD]6/2/2018[/TD]
[TD]517[/TD]
[TD]180[/TD]
[TD]999999999[/TD]
[TD]7) Greater Than 180 Days[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 6"]REAL EXAMPLE[/TD]
[/TR]
[TR]
[TD]Employee Number[/TD]
[TD]Name[/TD]
[TD]Hire Date[/TD]
[TD]Term Date[/TD]
[TD]Employment Length[/TD]
[TD]Tenure Type[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]Mr Excel Is Amazing[/TD]
[TD]5/1/2018[/TD]
[TD]6/2/2018[/TD]
[TD]32[/TD]
[TD] =IF(AND(E14>D2,E14 ETC ETC ETC ETC .. Check for all criterias in above table lol<e2=f2 etc="" etc<="" td=""></e2=f2>[/TD]
[/TR]
</tbody>[/TABLE]

 

[DigitalData]

Could have sworn I replied back. Thanks again Marcelo I appreciate the time and effort!

You also can use INDEX/MATCH, but it would be a simple formula, not a complex (intense) one
Using the data sample in post 18 try
F14 copied down
=INDEX(C$2:C$8,MATCH(E14,A$2:A$8))

M.