That works very well. The only problem with (me) and vlookup is, I have many employees and I do payroll in a different worksheet inside one work book. and I am using a vlookup for the tax table now and had it set for 2 years but now have to extend it for another 2 years and I Cannot figure out how to copy the previous good vlookup cell to the new and have it change the cell I need to change and have the vlookup box stay the same. So I copy down 104 weeks and then have to go to each week and change the vlookup so it is right and have to do this with 13 employees and one employee took me 2.5 hours last nigh. that's Why I was hoping to do a multiple if statement. I can do 1 if statement but need 5 in the same line and don't know what separator to use. Sorry for the length but its the best way I can fully explain.