MarkReddell
Board Regular
- Joined
- Sep 1, 2011
- Messages
- 210
- Office Version
- 365
- Platform
- Windows
- Mobile
Hello Mr XLers! This formula below only works when the date in my sales Tax Table matches the date in my materials date column. I need to be able lookup tax % with after 1/1/2019 which is the beginning date in my Sales Tax Table. Any help would be awesome! 
=IFERROR(ROUND(IF(COUNT([@Qty],[@[Unit Cost]])=2, [@Qty]*[@[Unit Cost]],IF(ISNUMBER(FIND("Tax",[@[Materials Destription]])), INDEX(SalesTax[Total %], MATCH(N9&T9,INDEX(SalesTax[Date]&SalesTax[City],,),1))*M7, IF(AND([@[Transaction Type]]="Refund", COUNT([@Qty],[@[Unit Cost]])=2), -[@Qty]*[@[Unit Cost]],""))),2),"")
=IFERROR(ROUND(IF(COUNT([@Qty],[@[Unit Cost]])=2, [@Qty]*[@[Unit Cost]],IF(ISNUMBER(FIND("Tax",[@[Materials Destription]])), INDEX(SalesTax[Total %], MATCH(N9&T9,INDEX(SalesTax[Date]&SalesTax[City],,),1))*M7, IF(AND([@[Transaction Type]]="Refund", COUNT([@Qty],[@[Unit Cost]])=2), -[@Qty]*[@[Unit Cost]],""))),2),"")
