Post

• NA
• 80
• 12.5k

# Search date with multiple criteria and in mutliple sheets in excel

Jul 22 2021 6:12 PM

I create a sheet with 32 sheet, 30 sheets are dates in which daily basis works updated in these 30 sheets have Location name, Date & Amount column. And 1 sheet is Summary, in which I want to view on which date & which location is not paid if location is not paid show blank or NotAvailable and if Location had paid amount then show both dates in which location sent and i received on.
I use below formula but it is
```
=IF(OR(\$C217=INDEX('1'!\$S:\$S,MATCH(D,'1'!\$Q:\$Q)),(\$C217=INDEX('2'!\$S:\$S,MATCH(D,'2'!\$Q:\$Q))),(\$C217=INDEX('3'!\$S:\$S,MATCH(D,'3'!\$Q:\$Q))),(\$C217=INDEX('4'!\$S:\$S,MATCH(D,'4'!\$Q:\$Q))),(\$C217=INDEX('5'!\$S:\$S,MATCH(D,'5'!\$Q:\$Q))),(\$C217=INDEX('6'!\$S:\$S,MATCH(D,'6'!\$Q:\$Q))),(\$C217=INDEX('7'!\$S:\$S,MATCH(D,'7'!\$Q:\$Q))),(\$C217=INDEX('8'!\$S:\$S,MATCH(D,'8'!\$Q:\$Q))),(\$C217=INDEX('9'!\$S:\$S,MATCH(D,'9'!\$Q:\$Q))),(\$C217=INDEX('10'!\$S:\$S,MATCH(D,'10'!\$Q:\$Q)))),CHAR(252),"")