Index match vba

		Microsoft Office Forums > Microsoft Excel > Excel
Index match vba

FAQ

Thread Tools

Display Modes

03-05-2015, 10:55 PM

grexcelman grexcelman is offline

Windows 7 32bit Index match vba

Office 2003

Novice

Join Date: Dec 2014

Posts: 21

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))

« 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
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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:31 AM.