Microsoft Office Forums - View Single Post - Index Match syntax

Thread: Index Match syntax

View Single Post

Old

03-05-2015, 07:17 AM

grexcelman grexcelman is offline

grexcelman is offline

grexcelman uses Windows 7 32bit

Windows 7 32bit grexcelman uses Office 2003

grexcelman uses Office 2003

Office 2003

Novice

The original poster

Join Date: Dec 2014

Posts: 21

grexcelman is on a distinguished road

Default

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

Reply With Quote