Rizwan Ahmed

Rizwan Ahmed

  • 2k
  • 78
  • 7.3k

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),"")

 


Answers (1)