Match4_4thNot0

Searches for three cells in three columns then checks for 4th column if not equal zero and return the row number if all were true

Edit 2024-11-13: Fixed more isues and changing some variables
Edit 2024-11-07: The beauty of creating functions while you work is that you have the perfect spot to test that function. This is great example. Fixed bug calculating Cond3 in function again causing function to return wrong match.
Edit 2025-05-12: Fixing Activesheet issue for Workbook WB

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 Bold.codes

Linkedin Login

Parameters

Val1, Col1, Val2, Col2, Val3, Col3, Col4, Optional Wb = "This", Optional Shee = "Active", Optional StartFromRow = 1

Permanenet link

Statistics

Views 9

Downloads 0

IDs

CodeID
DB ID

ANmarAmdeen
764
Attachments
Revisions

v4.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