#1
|
|||
|
|||
Index Match syntax
Any suggestions how I could write the syntax for this in VB? Code: =INDEX(Sheet1!$G$31:$G$63,MATCH(C4,IF(Sheet1!$D$31 :$D$63=Sheet2!B4,Sheet1!$B$31:$B$63),0)) |
Tags |
vba |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Translate INDEX(MATCH) into VBA | grexcelman | Excel Programming | 1 | 03-08-2015 05:06 PM |
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 |
Moving a Index/Match function | FraserKitchell | Excel | 2 | 01-19-2010 09:38 AM |