Hi everyone,

I had a trouble to get the row number of row that has match based on values on multiple columns. The formula Application.Match(strSearch, searchRange, 0) works for a single value match. I am looking to do something like this Application.Match(strSearch1 & strSearch2 , searchRange1 & searchRange2, 0) but it does not work.

In the Excel itself, we can use MATCH(A1&A2,A1:A10&B1:B10,0), so I can write Evaluate("MATCH(A1&A2,A1:A10&B1:B10,0)"). But, I do not have a fixed search range, I do not want it to always be A1:A10 and B1:B10, I need a dynamic range, such as from the first row to the last non-blank row, and it will change according to different data. So I need to find the last non-blank row using a VBA formula, and then include it in the range. But I could not find a way to write the formula, it always gives me a Syntax error.

Thank you for your help!!