Microsoft Office Forums - View Single Post - Index match vba

Thread: Index match vba

View Single Post

Old

03-05-2015, 10:55 PM

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

Reply With Quote