Translate INDEX(MATCH) into VBA

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Translate INDEX(MATCH) into VBA

FAQ

Thread Tools

Display Modes

03-08-2015, 05:06 PM

charlesdh

Windows 7 32bit Translate INDEX(MATCH) into VBA

Office 2010 32bit

Expert

Join Date: Apr 2014

Location: Mississippi

Posts: 382

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:53 AM.