angleright
New Member
- Joined
- Nov 4, 2024
- Messages
- 22
- Office Version
- 365
- Platform
- Windows
I am trying to migrate a formula from page "CCFTABLE" to page "SEARCH" while referencing the cells in page "CCFTABLE". this is the formula on page CCFTABLE that works (formula is in cell w30)
=FILTER(FILTER($H:$H:$N:$N,($K:$K=$S$10)*($J:$J=$R$10),"NOTHING FOUND"),{0,0,0,0,0,0,1}), R10 and S10 are the search criteria on page CCFTAABLE.
When I copy the formula to the search page, I change the search criteria to cells on the search page and this is my formula there (formula is in cell m3)
=FILTER(FILTER(CCFTABLE!$H:$N,(CCFTABLE!$K:$K=$D$10)*(CCFTABLE!$J:$J=$C$10),"NOTHING FOUND"),{0,0,0,0,0,0,1}) C10 and D10 are the search criteria on Page search
file can be found here beta ccftable.xlsm
If I can get this to work I will eliminate the search queries from CCFTABLE all together.
=FILTER(FILTER($H:$H:$N:$N,($K:$K=$S$10)*($J:$J=$R$10),"NOTHING FOUND"),{0,0,0,0,0,0,1}), R10 and S10 are the search criteria on page CCFTAABLE.
When I copy the formula to the search page, I change the search criteria to cells on the search page and this is my formula there (formula is in cell m3)
=FILTER(FILTER(CCFTABLE!$H:$N,(CCFTABLE!$K:$K=$D$10)*(CCFTABLE!$J:$J=$C$10),"NOTHING FOUND"),{0,0,0,0,0,0,1}) C10 and D10 are the search criteria on Page search
file can be found here beta ccftable.xlsm
If I can get this to work I will eliminate the search queries from CCFTABLE all together.
