Greetings to all! This is my first post!
I've been trying to handle MATCH function, concatenating two ranges for multiple columns search and it keeps telling me Error "13".
Here is the code line where it stops:
UserForm1.TextBox2.Text = Application.Index(Sheets("Plan1").Range("A1:E73"), Application.Match(UserForm1.ComboBox1.Text & Month(Date), Sheets("Plan1").Range("A:A") & Sheets("Plan1").Range("B:B")), 4)
Note that this comand works as a cell formula in the "Match Example" workbook when i use ctrl+shift+enter, but VBA is unable to handle that using the same structure.
Can someone help?