Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
index, match, offset worksheet function | Excel Worksheet Functions | |||
VBA equivalent for worksheet 'match'? | Excel Discussion (Misc queries) | |||
using index, match on another worksheet | Excel Worksheet Functions | |||
using worksheet functions INDEX and MATCH within a macro | Excel Programming | |||
VBA Equivalent Match/Index functions | Excel Programming |