|
|
|
|
#1
03-08-2015, 05:06 PM
|
|||
|
|||
Hi,
Perhaps this may help. I found it on line. test = Application.WorksheetFunction.Index(Sheets("Worker s List").Range("C3:C13"), Application.WorksheetFunction.Match(1, Sheets("Workers List").Range("D3  13"), 0), 1)
|
|
| Tags |
| index, index/match |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| 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 |
| Index, match in Pivottable and Pivotchart | Newbies | Excel | 0 | 11-15-2014 12:58 AM |
| 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 |
Windows 7 32bit 
Office 2010 32bit
Hybrid Mode