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 Boldcodes.com

Linkedin Login

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

Views 716

Downloads 108

CodeID
DB ID

ANmarAmdeen
754
Attachments
Revisions

v3.0

Monday
May
12
2025
Needs 1

Codes Required 1

Similar codes

Recent 4 by ANmarAmdeen 4

Random Codes 4