VBA Equivalent of Index and Match worksheet Fncs
 

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$11 36&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 Maycott
-----------------------------------------------------------------------
I Maycotte's Profile: http://www.excelforum.com/member.php...fo&userid=3560
View this thread: http://www.excelforum.com/showthread.php?threadid=56345

VBA Equivalent of Index and Match worksheet Fncs
 

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

--
Isaac


--
I Maycotte
------------------------------------------------------------------------
I Maycotte's Profile: http://www.excelforum.com/member.php...o&userid=35604
View this thread: http://www.excelforum.com/showthread...hreadid=563456