shiva_reshs
Board Regular
- Joined
- Sep 5, 2012
- Messages
- 68
Hello,
I am not able to figure out, what is wrong in this Indexing code.
I get application 1004 error msg.
Cross Posting
I am not able to figure out, what is wrong in this Indexing code.
Code:
<code>Range("R6").Select ActiveCell.FormulaR1C1 = "=IF($Q6="","",INDEX('Worker-Exempt'!B:B,MATCH($Q6,'Worker-Exempt'!A:A,0)))"</code></pre>
I get application 1004 error msg.
Cross Posting
HTML:
http://www.excelforum.com/excel-programming-vba-macros/960412-vlookup-to-index-matching-in-vba.html