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

Just looking at your formula, I see: "Approved',""NoMatch"

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

"Approved","NoMatch"

MIKE

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

Ask Your Question

Weekly Poll

Did you watch the X-Files when it was on TV?

Discuss in The Lounge

Poll History