Skip to main content
R
Raiko17-Peridot
17-Peridot
January 20, 2015
Solved

Using match function in a loop

  • January 20, 2015
  • 1 reply
  • 5291 views

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

Best answer by Raiko

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

1 reply

M
MikeArmstrong1-Visitor
1-Visitor
January 20, 2015

Please upload the Excel data.

R
Raiko17-PeridotAuthor
17-Peridot
January 20, 2015

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

Raiko

M
MikeArmstrong1-Visitor
1-Visitor
January 20, 2015

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

Terms & ConditionsAccessibility statement