vlookup - Is it possible to use vlookup to pull specific info like this?

Question

I am trying to pull the following from each group of Numbers -

CHG000509443 05-16-2016 22:48:41 for the Requested
CHG000509443 05-17-2016 13:14:35 for the Approved

Note 1 - It is always the first Requested in each group - See CHG000509448

Note 2 - It is always the 0 duration Approved in each group - See CHG000510593

Answer 1

This code in VBA will do it:

Public Sub ReqandAppr()
    '****************
    ' variables
    SourceSheet = "Sheet1" 'name of source sheet
    DestSheet = "Sheet2"   ' name of destination sheet
    columntocheck = 5  'Column to check "Requested" or "Approved"
    firstrow = 2 'first row in source sheet
    destrow = 1  'first row in destination sheet
    'end of variables
    '*******************
    Dim wkb As Workbook
    Dim wksSource, wksDest As Worksheet
    Set wkb = ThisWorkbook
    Set wkSource = wkb.Sheets(SourceSheet)
    Set wkDest = wkb.Sheets(DestSheet)
    wkDest.Rows.Clear
    totalrows = wkSource.Cells(Rows.Count, 1).End(xlUp).Row
    For i = firstrow To totalrows
        If wkSource.Cells(i, 1) <> wkSource.Cells(i - 1, 1) Then
            requestedfound = False
            approvedfound = False
        End If
        Select Case wkSource.Cells(i, columntocheck)
            Case "Requested"
                If requestedfound = False Then
                    wkSource.Rows(i).Copy Destination:=wkDest.range("A" & destrow)
                    requestedfound = True
                    destrow = destrow + 1
                End If
            Case "Approved"
                If approvedfound = False And wkSource.Cells(i, columntocheck - 1) = 0 Then
                    wkSource.Rows(i).Copy Destination:=wkDest.range("A" & destrow)
                    approvedfound = True
                    destrow = destrow + 1
                End If
        End Select
    Next i
End Sub

Open VBA/MAcros with ALT+F11, under ThisWorkbook insert a new module and paste the code on the right side.

Check the value of the variables and execute it.