LinkBack URL
About LinkBacks
What if you replace the formula in E2 to:
=SUMPRODUCT(--ISNUMBER(SEARCH(LEFT('BEFORE Cost of Supplies'!$B$2:$B$8,FIND(" ",'BEFORE Cost of Supplies'!$B$2:$B$8)-1),'BEFORE Item Catalog'!C2)),'BEFORE Cost of Supplies'!$C$2:$C$8)
What if you replace the formula in E2 to:
=SUMPRODUCT(--ISNUMBER(SEARCH(LEFT('BEFORE Cost of Supplies'!$B$2:$B$8,FIND(" ",'BEFORE Cost of Supplies'!$B$2:$B$8)-1),'BEFORE Item Catalog'!C2)),'BEFORE Cost of Supplies'!$C$2:$C$8)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks