Multiple Criteria Lookup - VBA Help

[jaya]

Can some assist me to replace 1 in A1 and B1 with the variable Rw in the following please.

ElxJobNo = Evaluate("INDEX(Index(Jobnumbers,0,1),MATCH(indirect(""A1"")&indirect(""B1""),Index(Jobnumbers,0,3)&Index(Jobnumbers,0,4),0))")

This works as it is but I am unable to use the incremental variable Rw to go though a series of rows.

Thanks in advance.

 

[jaya]

Don't bother found the answer myself.

Replaced ""A1"" with " + Chr(34) + "A" + Trim(Str(Rw)) + Chr(34) + "

Sorry if any of you spent any time on this.

 

[vidplaylist]

Don't bother found the answer myself.

Replaced ""A1"" with " + Chr(34) + "A" + Trim(Str(Rw)) + Chr(34) + "

Sorry if any of you spent any time on this.

Hi, i am trying with your approach to match multiple criteria in index match formula with loop. But its not working.

Could you give me some tips?

Thanks,