Using MATCH to find row number based on a two-column lookup.

Hi All,

I'm needing to find the actual number of a desired row based upon a lookup of two values in a column. For example, consider this table:

Col1	Col2	Col3	Col4
1	A	XXX	YYY
1	B	YYZ	AFC
2	A	GDS	CCV

Say I wanted to find the row that had 'Col1' as '1' and 'Col2' as 'B', how could I construct a match function to return the row number?

I've tried things like:

Critera1 = "1"
Critera2 = "B"
myRow = Application.WorksheetFunction.Match(Critera1 & Critera2, Range("RefSheet!$A$2:$A$4") & Range("RefSheet!$B$2:$B$4"), 0)

But this is continually returning an error.

Thanks in advance for any help offered.
Anubis.

Please Login or Register  to view this content.

Kind regards
Leo

Thank you both for your solutions. I was hoping there would be a one-liner function that might do the job, but this works perfectly as an alternative.

Thanks
Anubis.

Please Login or Register  to view this content.