IF stament wih date

[guaya81]

Hello

can someone please try to help me and let me know what I did wrong in this formula, what I'm trying to do is to vlookup an amount from another sheet by using an IF statement of dates

example if an invoice has a date of 05/05/2018

the formula needs to go and determine if these criteria meet the date of between 05/01/2018 -05/31/2018

if this is between the vlookup

=IF(AND(Query1[@[Invc Date]]<='Comm 3-7-18'!$A$4:$A$158,Query1[@[Invc Date]]>='Comm 3-7-18'!$B$4:$B$158),VLOOKUP(Query1[@Item],'Comm 3-7-18'!C:G,5,0),"0")

thanks

 

[C Moore]

If there are multiple values that meet the criteria it will make it hard to find.