Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X
Hello folks,
I'm mystified. I'm trying to identify matching values in two different arrays (see attached file). Works fine when using match in a single equation, however fails when I let it run through a loop.
It's probably me and I'd appreciate any help.
Raiko
P.S.
MC15 on a win7, 64 bit machine.
Solved! Go to Solution.
The problem is because there isn't always a match; but using "on error" catches this - see attached.
Alan
The problem is because there isn't always a match; but using "on error" catches this - see attached.
Alan
Thank you Alan. That was the clue I needed.
Raiko