Search code examples
excelindexingexcel-formulaevaluate

Why do I get Error 2042 in VBA Evaluate INDEX/MATCH?

I asked for advice everywhere but with no help so far!

= Evaluate("INDEX(TEMPDB!E" & lrCHIIMPORT2 + 1 & ":E" & lr3CHIMPORT2 & ", 
 MATCH(STATIONS!B" & RARTSTAT3 & "& STATIONS!" & matchARTIST & "1, TEMPDB!C" & 
 lrCHIIMPORT2 + 1 & ":C" & lr3CHIMPORT2 & " & TEMPDB!A" & lrCHIIMPORT2 + 1 & 
 ":A" & lr3CHIMPORT2 & "))")

I get

Error 2042

Both criteria is STRING, output is INTEGER or STRING!

Solution 
  • Sheets("STATIONS").Evaluate("INDEX(TEMPDB!E" & lrCHIIMPORT2 + 1 & ":E" & 
lr3CHIMPORT2 & ", MATCH(STATIONS!B" & RARTSTAT3 & "& STATIONS!" & matchARTIST 
& "1, TEMPDB!C" & lrCHIIMPORT2 + 1 & ":C" & lr3CHIMPORT2 & " & TEMPDB!A" & 
lrCHIIMPORT2 + 1 & ":A" & lr3CHIMPORT2 & ",0))")

    i can't believe... Just FALSE on the end...!