• 503K Members
• 7,116 Online
• 601K Conversations

## Need help in Index Match function

Highlighted
Occasional Contributor

# Need help in Index Match function

Hi, I am trying to Count no.s equals to ZERO from column DB with this formula, but getting error. Can anyone help me.

There are 2 sheets in same workbook. I am trying to countif some data.

Formula used is :

=COUNTIFS(Dealer!\$D:\$D,State!\$B5,Dealer!\$K:\$K,"Active",Dealer!DB:DB,"<=0")

This formula works well. But...

The case is, I don't want to use DB:DB in this formula, I want excel to refer this column automatically. That's why I tried using Index Match (referring current Month as "July" & "B")

Refer cell DB1 = 7B

Refer cell V1 = 7B (in 2nd sheet)

=COUNTIFS(Dealer!\$D:\$D,\$B5,Dealer!\$K:\$K,"Active",INDEX(Dealer!\$CP\$4:\$DE\$1137,,MATCH(\$V\$1,Dealer!\$CP\$1:\$DE\$1,0)),"<=0")

4 Replies

# Re: Need help in Index Match function

If a picture paints a thousand words, a sample Excel file, with dummy data and manually entered results, paints a million explanations!

# Re: Need help in Index Match function

@Sarav45 , in second INDEX the range shall be same size, like

`INDEX(Dealer!\$CP:\$DE,0,MATCH(\$V\$1,Dealer!\$CP\$1:\$DE\$1,0))`

# Re: Need help in Index Match function

thank you so much, my bad....

# Re: Need help in Index Match function

@Sarav45 , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies