Can I nest an IF in a VLOOKUP?

[Anjin]

Hi,

I would like to know if I can nest an IF formula in a VLOOKUP. I have had two very nice people give me solutions BUT the solutions are not nesting an IF in my VLOOKUP. My VLOOKUP worked but I can not figure out how to make the IF work with it. I keep getting a VALUE error. Column I has "Date Shipped", I would like to use the 03/01/2013 format here. Column J has "Additional Shipping Costs", this is where I want to use my VLOOKUP to look on sheet 2 at a table named DOW(Day of Week). I got this far but what I can not make work is the IF it is Thurs-Sun than add Cell F14 (Cost of extra shipping for Thurs-Sun) + F15+F16. IF Mon-Wed than only add cells F15 +F16. I would greatly appreciate if someone could tell me if this is even possible or to look at my attempts on the workbook and see what I am doing wrong with my IF part.
Thanks

Original Post below-----


Hi,
I am learning excel and have a project I am working on that I need help with. I have "Date Shipped", in Column I. In Column J, I have Additional Shipping Costs. I have a table on Sheet 2 that is named DOW (Days of Week). 1=Sunday, 2=Monday, etc. I have an additional chart on Sheet 1 that explains the potential additional costs for shipping, i.e. blue ice =$5, box =$5, shipping Thursday through Sunday is an additional $10. In cell J2 I have a formula, (that worked to my amazement) it is =VLOOKUP(WEEKDAY(I2),DOW,2,FALSE) I wanted it to look at the date in I2, reference my DOW table, column 2 which is the day of the week, and give me the day of the week. It worked!!! Now the problem. I am wondering how or if I can nest another function in there that if the day of the week is Thurs, Fri, Sat, or Sun, it will reference cell F14 which is the additional fee $10 for shipping on those days, plus cells G14 and H14 for $5 for other shipping costs. If it is not Thurs-Sun then I would like it to just include shipping for G14 and H14. Is this possible? When I try the if function the info I put in seems to be fine until I hit ok then it wants I get an error or it wants to correct it and if I let it and I get an error anyway. I hope this is not too confusing. I am not sure if my attachment which has a screen print of my data made it but if it did maybe that will help to visualize. You cannot see the DOW table on sheet 2 but that should be ok. Can anyone help? I would greatly appreciate it.