Index / Match in VBA, works fine until I added the second Match function in.
What I'm trying to do is get the index result depending on whether two other columns in the table have certain data in them.
So the Row part of the index function (the match functions) is running on two criteria. Works with just one no problems, and I've tried it with both Match functions in it alone, and it works with either one perfectly. just gives me a type mismatch when they are both in.
The data does exist, sTitle is populated from a drop down select and the drop read from table range its running the match in, and sName also populates from a drop down that populates based on what is listed as in same rows as the project picked (sTitle)
sDate = Application.Index(Range("Projects[Start Date]"), Application.Match(sTitle, Range("Projects[Title]"), 0), Application.Match(sName, Range("Projects[Resource]"), 0))