Skip to main content
17-Peridot
Dec 16, 2014 7:50 AM UTC
Solved

Problem with match function in a loop

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.

19-Tanzanite
Dec 16, 2014 9:21 AM UTC

The problem is because there isn't always a match; but using "on error" catches this - see attached.

Alan

2 replies

19-Tanzanite
Dec 16, 2014 9:21 AM UTC

The problem is because there isn't always a match; but using "on error" catches this - see attached.

Alan

Translate
Raiko17-PeridotAuthor
17-Peridot
Dec 16, 2014 9:39 AM UTC

Thank you Alan. That was the clue I needed.

Raiko

Translate