I need to calculate some construction costs using a reference table provided on another tab.

I'm trying to use the IF(AND) function to determine if the current month is between the two months of construction, and if so, use the vlookup function to find the construction costs and multiply them by the costs and % ownership, otherwise, have it equal to zero.

I have included the formula I am using-- am I missing something here? What can I do to fix this? Thanks so much!


=if(and(G6>=$A$7,G6<=$C$7),vlookup($B$4,'Reference Tables'!$K$2:$W$7)*$F$7*$D$8),0))