Application.Match with 2 Dimenstional Array
Posted on 2014-04-21
I am using VBA in MS Excel 2010 and SQL Server 2008.
I have a scenario where I am filling out a spreadsheet from a data file that has 2 columns.
I then create a recordset from a SQL 2008 db that contains 4 fields, 2 of which I want to compare to the data filled out from above.
I have done this before with 1 variable by running a loop on the SQL recordset and attempting to find the value with Application.Match.
How do I do this with 2 variables? I want to see if there is a line with both variables in the same record in my SQL table.