MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match
Vertical matches for a value in a column

Edit 2025-12-28: Adding ability to return 0 if no cell found in column

CodeFunctionName What is this?

Public

Tested

Original Work

Access is limited.

Login here using your Linkedin account. to see or download code.

No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydevlib.com

Linkedin Login

Val1, Col1, Optional Wb, Optional Shee, Optional StartFromRow

Views 3,302

Downloads 1,316

CodeID
DB ID

ANmarAmdeen
790
Attachments
Revisions

v3.0

Sunday
December
28
2025

Codes Required 0

Similar codes

Recent 4 by ANmarAmdeen 4

Random Codes 4