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.

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

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

Views 7

Downloads 0

CodeID
DB ID

ANmarAmdeen
701
Attachments
Revisions

v3.0

Wednesday
November
13
2024