How do you use the IF and AND function with numerouse amount of Data????

[CSTEIGER]

okay so here goes...i need to enter a formula using the IF and AND functions to determin the number of vacation days based on these vacation rules, 15 days for FT who worked 4 or more years, 10 days for FT who worked 2 years but less than 4, 5 days for FT who worked 1 year but less than 2 and 0 days for everyone else. this is what I have so far
=IF(AND(B6="FT",D6>=2),10,0)
my problem is that I cant figure out how to put it all intoone formula so I dont have to make up 109 of them for each person.Attached is my worksheet.

[Kevin@Radstock]

Maybe something along these lines, in E6 and copy down.

=IF(B6<>"FT","",LOOKUP(D6,{0,1,2,4},{0,5,10,15}))