MatchIF5

Searching for rows having 5 values in 5 columns
Like Match4, Match3 and others, but this one with 5 conditions.

Edit 2025-05-12: Fixing the activesheet issue of thisworkbook
Edit 2024-05-16: Updated version to accept wild card * in all Val1, Val2, Val3, Val4 and Val5 fields.
Also accepts <=, >=, <, or > to compare against numbers and <> to compare against strings and numbers

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 Mydev.net

Linkedin Login

Parameters

Val1, Col1, Val2, Col2, Val3, Col3, Val4, Col4, Val5, Col5, Optional WB = "This", Optional Shee = "Active", Optional StartFromRow = 1

Permanenet link

Statistics

Views 716

Downloads 108

IDs

CodeID
DB ID

ANmarAmdeen
754
Attachments
Revisions

v3.0

Monday
May
12
2025
Needs 1

Requirements

Codes Required 1

Similar Codes

Similar codes

By Developer

Recent 4 by ANmarAmdeen 4

Random Codes

Random Codes 4