This was super helpful, thanks for making it! Question. I keep a tracking log for accounts that I work on every month. Every month is a different sheet. I created a column for "Received Prior?" (which is column I), that I want it to look back each month to see if I have already worked on that account. I'm using the formula (in my May worksheet): =COUNTIF(Jan!$B$2:$B$181,$B4)+COUNTIF(Feb!$B$2:$B$181,$B4)+COUNTIF(Mar!$B$2:$B$181,$B4)+COUNTIF(Apr!$B$2:$B$181,$B4). My "B" Column is "Account Names". This is suppose to compare the name in the current sheet name column with all the names of accounts in prior months. I'm fine with the "1" response that is given, but I was wondering if I could ask it to also give me the other sheet it was found in? Hopefully this makes sense. Thanks for your feedback.
![[안방1열 직캠4K] 베이비몬스터 치키타 'DRIP' (BABYMONSTER CHIQUITA FanCam) @SBS Inkigayo 241110](http://i.ytimg.com/vi/tnlxo79cAqY/mqdefault.jpg)
This was super helpful, thanks for making it! Question. I keep a tracking log for accounts that I work on every month. Every month is a different sheet. I created a column for "Received Prior?" (which is column I), that I want it to look back each month to see if I have already worked on that account. I'm using the formula (in my May worksheet): =COUNTIF(Jan!$B$2:$B$181,$B4)+COUNTIF(Feb!$B$2:$B$181,$B4)+COUNTIF(Mar!$B$2:$B$181,$B4)+COUNTIF(Apr!$B$2:$B$181,$B4). My "B" Column is "Account Names". This is suppose to compare the name in the current sheet name column with all the names of accounts in prior months. I'm fine with the "1" response that is given, but I was wondering if I could ask it to also give me the other sheet it was found in? Hopefully this makes sense. Thanks for your feedback.