Row Number in With Value Exists in One Column AND A second value exists in a second column

[Ark68]

I usually use the MATCH function to find a particular row number based on the criteria I have available.

For example

trew = Application.WorksheetFunction.Match(RID, ws_psttemp.Columns("A"), 0)

Will provide me the row number in which the value of RID can be found in column A of worksheet ws_psttemp.

I need to take this one set further by adding a second criteria. I'm not sure if I can use the MATCH function anymore

So, what I need to do is find the first row number in which column A = the value of RID AND column B = "Diamond"

Is anyone able to suggest a vba approach to this?

 

[Ark68]

Found it here ... https://www.mrexcel.com/forum/excel...t-row-number-matching-criteria-2-columns.html

 

[DanteAmor]

Try this

    n = ws_psttemp.Name
    trew = Evaluate("=MATCH(""" & rid & """&""Diamond""," & n & "!A1:A100&" & n & "!B1:B100,0)")