VBA Equivalent of Index and Match worksheet Fncs

[I Maycotte]

Hello everyone,

I recently found this thread '' (http://tinyurl.com/qxyrf)

on a very similar topic. However, it falls a bit short of what I am
interested in.


Here is my Index fnc in excel:


= INDEX(Autofilter!$H$2:$H$1136,MATCH("Progressive"&"Salary
Reduction"&"Trail"&"Heap"&E$9&""&"0-40",Autofilter!$A$2:$A$1136&Autofilter!*$B$2:$B$1136&Autofilter!$C$2:$C$1136&Autofilter!$D$2:$D$1136&Autofilter!$E$*2:$E$1136&Autofilter!$F$2:$F$1136&Autofilter!$G$2:$G$1136,0)



As you can see, I am not just interested in using the index fnc with

single match function criteria but with multiple, and the example i
the other thread
does not do that.


If anyone knows how to write this in VBA or has the knowledge to poin
me in
the right direction, your help will be highly appreciated.


Thank you,


Isaa

 

[I Maycotte]

If anyone can help. I'd appreciate it. Thank you.