VBA Equivalent of Index and Match worksheet Fncs
 

Hello everyone,

I recently found this thread
(http://groups.google.com/group/micro...1ded9d055ad397)
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$113 6&Autofilter!$C$2:$C$1136&Autofilter!$D$2:$D$1136& Autofilter!$E$2:$E$1136&Autofilter!$F$2:$F$1136&Au tofilter!$G$2:$G$1136,0))

As you can see, I am not just interested in using the index fnc with a
single criteria but with multiple, and the example in the other thread
does not do that.

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


Sincerely,


Isaac