|
|
#1
03-05-2015, 10:55 PM
|
|||
|
|||
Index match vba
trying to write this function in vba. Does anyone know how to express this syntax? This is making me nuts.
=INDEX(Sheet1!$G$31:$G$63,MATCH(C4,IF(Sheet1!$D$31 :$D$63=Sheet2!B4,Sheet1!$B$31:$B$63),0)) 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Translate INDEX(MATCH) into VBA | grexcelman | Excel Programming | 1 | 03-08-2015 05:06 PM |
| Index Match syntax | grexcelman | Excel Programming | 0 | 03-05-2015 07:17 AM |
| UDF multiple IFs INDEX-MATCH | grexcelman | Excel Programming | 0 | 02-22-2015 04:20 PM |
 Index Match function
|
jackzha | Excel | 5 | 12-03-2014 12:43 PM |
| Help with multiple match and index formula | ryanwood | Excel | 1 | 09-12-2012 07:53 AM |
Windows 7 32bit 
Office 2003
Linear Mode
