Index Match syntax

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Index Match syntax

FAQ

Thread Tools

Display Modes

03-05-2015, 07:17 AM

grexcelman grexcelman is offline

Windows 7 32bit Index Match syntax

Office 2003

Novice

Join Date: Dec 2014

Posts: 21

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:37 PM.