Skip to main content
Raiko17-Peridot
17-Peridot
Jan 20, 2015 8:26 AM UTC
Solved

Using match function in a loop

Hello folks,

I ran into this problem of the match function. When used in a loop it claims to not have found a match. When used on its own it works just fine; see attached worksheet.

Does anybody know why? I'm using MC15 on a Win 7 machine.

Thanks in advance

Raiko

RaikoAnswer
17-Peridot
Jan 20, 2015 8:54 AM UTC

Tghank you Mike for the hint. It led me to the solution. I simply had to trap the error when match didn't find a solution and now it's working like a charm.

Raiko

View in thread

16 replies

MikeArmstrong1-Visitor
1-Visitor
Jan 20, 2015 8:28 AM UTC

Please upload the Excel data.

Translate
Raiko17-PeridotAuthor
17-Peridot
Jan 20, 2015 8:31 AM UTC

here we go Mike. It ought to work however with any Excel data.

Raiko

Translate
MikeArmstrong1-Visitor
1-Visitor
Jan 20, 2015 8:36 AM UTC

Firstly are calling the wrong column of Q? Should you be calling column <2>?

Translate
Terms & ConditionsAccessibility statement