VBA for arrays and decision

Good day. I am venturing out into using arrays. I have searched the net and have been able to make an array work in a spreadsheet. The formula is shown below in the FormulaArray statement.

Now I need to code in VBA and use variable. The code below is a part of what I have so far. My need is to check for plt in column A and aud_date in Column B. If found in the same row, exit out as the information already exists. If both are not found on the same row, then execute to add the information. I have the code running that allows the entry of the information but have not included here. The MsgBox statements are just for my own checking and will be removed when I have the code working.

I assigned a variable is_done so that if the 2 pieces of information exist on the same row, you get true and exit, otherwise execute the entry code. Maybe I do not even need to do so. Thoughts?

Is If...Then...Else the best method?

Please Login or Register  to view this content.

Thanks in advance.

Ok. Thanks. So do I put this in an If...Then...Else? Do I need to do something for a TRUE and FALSE situation?

I have tried the following code. It executes even when the main file has a match for plt and aud_date on the same row. The intent is if an exact match is found, exit out. Thoughts?

Please Login or Register  to view this content.

One last request...please.