Translate index/match function to vba code

[vbahelp123]

Hello i need a little help here.


how do i translate this to a vba code?


=INDEX('Workers List'!D3:D13,MATCH('Workers List'!C4,'Workers List'!C3:C13,0),1)


what i have done is


test = Application.Index(Sheets("Workers List").Range("C3;C13"), Application.Match(1, Sheets("Workers List").Range("D3:D13"), 0), 1)


But i keep getting an error, may i know whats wrong with it?

 

[maeyks]

Hello,

I, too, am currently using the following formula in my excel sheet:

=IFERROR(INDEX('Master Data'!$V$8:$V$5198,MATCH(M6,'Master Data'!$U$8:$U$5194,FALSE),1),"")

How can i convert it to a VB program? I tried using the example give above but there was an error, outside the range, something. Please help.
Thank you

 

[karolina1406]

Re: need help to translate index/match function to vba code

hi,

Can someone hep? i am trying to bring translated text to the original table using index(match formula but it's limited to 256 characters. I am using =INDEX(Translation,MATCH($G10,Text1,0)) formula. How can i use vba to do the same?