Thread: Calculate withholding

Thanks Darkyam, I appreciate your help!

Before I got your latest response, here is what I did...
On my main table, I added two columns, one ('O' column) with the filing status S (only option for right now) and another column ('P' column) with either a 0,1,2 in it (I know it is limited to only having the "single option" and only allowances for up to 2) and then put in the following formula:
VLOOKUP(N17,(SingleWkly!$A$4:$M$71, IF(P17=0,3,IF(P17=1,4,IF(P17=2,5,0)))) I know that this doesnt allow for all conditions, but it does work for the limited options I have. I will try your formula and see if I can follow along with the steps you do and if not, I will break it down slowly and learn the steps. Thanks again for your patience!!

Boneob