Excel Vba Index Match

Posted on admin
Excel Vba Index Match Rating: 4,2/5 248 votes
Excel vba index match function youtube
  1. Excel Vba Index Match Type Mismatch
  2. Excel Vba Index Match Closed Workbook
Excel Vba Index Match

Excel Vba Index Match Type Mismatch

Vba

Excel Vba Index Match Closed Workbook

I have this formula on the first column in my sheet: =IFERROR(INDEX(Plan2!$A$1:$K$20;MATCH(Plan3!B2;Plan2!$B$1:$B$20;0);MATCH(Plan3!$A$1;Plan2!$A$1:$K$1;0));')And it fits perfectly for what I want: look up on Plan2 (my databse) for the information on column B of Plan3 by matching the result by matching the header of table.What I want know is to translate this to a VBA that do the same thing.