Index Match in VBA = Error "Expected: ="

[OpieWinston]

I’m trying to use an index match formula with a loop, and am getting the compile error “Expected: =” before I get a chance to end the loop. Would someone please tell me what I’m doing wrong?

Please Login or Register  to view this content.

Thanks for the help!

[xlnitwit]

Hi,

You have called a function that returns a value but you aren't doing anything with that value- you need to assign it to something, whether it be a cell or variable.

[OpieWinston]

And the error went away - thank you very much!