Using COUNTIF on a Range with Cross-Sheet References

I am attempting to use a COUNTIF formula on a column of cells that have VLOOKUP formulas pulling in information from another sheet.

The COUNTIF formula returns a #NO MATCH. When I copy/paste the VLOOKUP info into text only, the COUNTIF formula works but this destroys the advantage of using a VLOOKUP formula in the first place as now I must manually re-enter the formula on each update.

Does anyone have a workaround for this?

Find more posts tagged with

Formulas

Real Estate

Project Management

Cell linking

Comments

Chak Khiam

Without knowing how your formula looks like, I am making a guess that it could be caused by the following:

If you had not included "false" as the match type in your VLOOKUP statement, then you might want to add it (or replace "true") to retrieve an exact match.

Paul Newcome

Are you able to post your current formulas and some screenshots with confidential and/or sensitive data hidden, remove, or replaced with "dummy data"?

VLOOKUP results can be a headache in regards to their use in other formulas and calculations, but there are so many variables that could come into play that finding a solution for you without more detail would be extremely difficult.

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?