Solved IF(Countif comes back with FALSE instead of data

December 24, 2012 at 07:21:37
Specs: Windows XP

I have a rather long function I set up but all I can get it to say is 'False' instead of what I typed in. The Evaluate Formula shows it working through and not finding a match but if there's no match, I want it to come back as "No Match". And there are around 5000 account numbers on this whole project so it's rather large.

There are two workbooks. One has the managerment's Total Exit list which is where the formula is and where there are account numbers we need to find in the other workbook. The other workbook has four worksheets and I need to check for the account number. If the account number matches on the first page, I need the formula to say 'First Page' (as an example) so we know where that account number is located. The actual workbook/worksheet names are long but they are in this formula. Can anyone see what I've done wrong?

=IF(COUNTIF('[Remediation Exits Nov 2012 092612 Mgt File 11-13-2012updated.xlsx]Nov Complex Exits List'!B:B,B10433),"November Exits",IF(COUNTIF('[Remediation Exits Nov 2012 092612 Mgt File 11-13-2012updated.xlsx]Exit Customers already closed'!B:B,B10433),"Closed",IF(COUNTIF('[Remediation Exits Nov 2012 092612 Mgt File 11-13-2012updated.xlsx]Future Complex exits'!B:B,B10433),"Future Exits",IF(COUNTIF('[Remediation Exits Nov 2012 092612 Mgt File 11-13-2012updated.xlsx]approved w review date'!B:B,B10433),"Approved',""NoMatch"))))


See More: IF(Countif comes back with FALSE instead of data

Report •


#1
December 24, 2012 at 11:22:33
✔ Best Answer

Just looking at your formula, I see:

"Approved',""NoMatch"

You have a single quote mark and comma, which should probably be:

"Approved","NoMatch"

MIKE

http://www.skeptic.com/


Report •

#2
December 26, 2012 at 06:25:54

Thank you! After staring at it for a while, I just couldn't look anymore!

Report •

Related Solutions


Ask Question