Index/match vba code

**thanny88** · 03-16-2017, 09:35 AM

Hello,

Wondered if anyone could help. I wanted to convert the following formula into VBA code but I think I may done something wrong.

FORMULA:

=INDEX('PPG DATASHEET'!$J$2:$J$30000,MATCH($D$1,'PPG DATASHEET'!$B$2:$B$30000,0))

VBA CODE

Please Login or Register  to view this content.

The value I am trying to match instead of cells D1 is in txtMDMCode.Value.

Appreciate the help

**Marc L** · 03-16-2017, 09:51 AM

Hi !

Use Evaluate method …

**kvsrinivasamurthy** · 03-16-2017, 10:38 AM

Try this code

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

Index/match vba code

LinkBack

Thread Tools

Rate This Thread

Display

Index/match vba code

Re: Index/match vba code

Re: Index/match vba code

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] index match to concatenate using UDF code

Vlookup code to Index/Match code help

Index/Match formula into VBA code

Index & Match VBA Code

[SOLVED] VBA Code to Match Index Array

INDEX/MATCH style VBA code

Index/Match-corresponding zip code in column

Bookmarks

Bookmarks

Posting Permissions