All,

I am currently using the .Cells.Find method to put values into my userform. It does well finding one specific value in a cell but I can't figure out how to get this method to look at two values in two different cells. For example, I would like it to do the following:

If column B = sFind value and column C = sFind2 value, then pull the values from that row into the userform.

Can anyone please help? I've looked everywhere and can't seem to find the solution that I am looking for.

Thank you in advance for your help. 


With dataSheet
            On Error Resume Next
            lRowFnd = .Cells.Find(What:=sFind, After:=Cells(1, 2), LookIn:=xlValues, _
            LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlDown, MatchCase:=False, _
            SearchFormat:=False).Row

            'Required
            changeNum = .Cells(lRowFnd, 2)
            lineNum = .Cells(lRowFnd, 3)
            requestBy = .Cells(lRowFnd, 4)
            dateSub = .Cells(lRowFnd, 5)
            changeType = .Cells(lRowFnd, 6)
End With