"#NO MATCH" Error

Tahreem Tariq

Hi @Paul Newcome,

I was using "COUNTIFS" formulas and they were working completely fine until today all of them are giving me an "#NO MATCH" error. Everything seems fine with the sheet and the formulas. Would you happen to know why this might be happening.

Formula: =COUNTIFS(Status:Status, OR(@cell = "Requested", @cell = "Demoed"), [Automation Category]:[Automation Category], OR(@cell = "Data Processing", @cell = "Data Visualization", @cell = "Robotics", @cell = "Workflow"))

Thank you!

Paul Newcome

Double check your source data to see if that error is present anywhere. Are any of the ranges you are referencing populated with a VLOOKUP or an INDEX/MATCH?

Paul Newcome

Double check your source data to see if that error is present anywhere. Are any of the ranges you are referencing populated with a VLOOKUP or an INDEX/MATCH?

Tahreem Tariq

Yes, I do see an error in the source data. It's referencing a Vlookup which is giving the "#NO MATCH" error. Thank you!

Paul Newcome

Happy to help. 👍️

mgilkessmith

@Paul Newcome I am having a similar issue but I need to also use the vlookup in the range that I am using with my countif formula. How do I count all the cells in a column that are populated with a number and not text if there is a vlookup formula being used?

Paul Newcome

@mgilkessmith I'm not sure I follow. Are you able to provide some screenshots for reference?