Lookup values in a range using two or more criteria and return multiple matches

    I have two sheet in raw data, and 2nd sheet is the processed data


    The Sample Data are :


    Sheet 1:


    [TABLE="width: 403"]

    [tr]


    [td]

    AFC001

    [/td]


    [td]

    LBE05ACCFB

    [/td]


    [td]

    G42BE200067

    [/td]


    [/tr]


    [tr]


    [td]

    AFC001

    [/td]


    [td]

    LBE05ACCFB

    [/td]


    [td]

    G42BE202067

    [/td]


    [/tr]


    [tr]


    [td]

    AFC001

    [/td]


    [td]

    LBE05ACCFB

    [/td]


    [td]

    G42BE203067

    [/td]


    [/tr]


    [tr]


    [td]

    AFC001

    [/td]


    [td]

    LBE05ACCFB

    [/td]


    [td]

    G42BE255317

    [/td]


    [/tr]


    [tr]


    [td]

    AFC001

    [/td]


    [td]

    LBE05ACCFX

    [/td]


    [td]

    G42BE200067

    [/td]


    [/tr]


    [tr]


    [td]

    AFC001

    [/td]


    [td]

    LBE05ACCFX

    [/td]


    [td]

    G42BE202067

    [/td]


    [/tr]


    [tr]


    [td]

    AFC001

    [/td]


    [td]

    LBE05ACCFX

    [/td]


    [td]

    G42BE203067

    [/td]


    [/tr]


    [tr]


    [td]

    AFC001

    [/td]


    [td]

    LBE05ACCFX

    [/td]


    [td]

    G42BE255317

    [/td]


    [/tr]


    [tr]


    [td]

    AFC002

    [/td]


    [td]

    LBE05CR3DB

    [/td]


    [td]

    IC1BE112700

    [/td]


    [/tr]


    [tr]


    [td]

    AFC002

    [/td]


    [td]

    LBE05CR3DB

    [/td]


    [td]

    IC1BE112710

    [/td]


    [/tr]


    [tr]


    [td]

    AFC002

    [/td]


    [td]

    LBE05CR3DX

    [/td]


    [td]

    IC1BE112700

    [/td]


    [/tr]


    [tr]


    [td]

    AFC002

    [/td]


    [td]

    LBE05CR3DX

    [/td]


    [td]

    IC1BE112710

    [/td]


    [/tr]


    [tr]


    [td]

    AFC003

    [/td]


    [td]

    LBE05CORPB

    [/td]


    [td]

    G42BE200051

    [/td]


    [/tr]


    [tr]


    [td]

    AFC003

    [/td]


    [td]

    LBE05CORPB

    [/td]


    [td]

    G42BE202051

    [/td]


    [/tr]


    [tr]


    [td]

    AFC003

    [/td]


    [td]

    LBE05CORPB

    [/td]


    [td]

    G42BE203051

    [/td]


    [/tr]


    [tr]


    [td]

    AFC003

    [/td]


    [td]

    LBE05CORPB

    [/td]


    [td]

    G42BE255311

    [/td]


    [/tr]


    [tr]


    [td]

    AFC003

    [/td]


    [td]

    LBE05CORPF

    [/td]


    [td]

    G42BE200051

    [/td]


    [/tr]


    [tr]


    [td]

    AFC003

    [/td]


    [td]

    LBE05CORPF

    [/td]


    [td]

    G42BE202051

    [/td]


    [/tr]


    [tr]


    [td]

    AFC003

    [/td]


    [td]

    LBE05CORPF

    [/td]


    [td]

    G42BE203051

    [/td]


    [/tr]


    [tr]


    [td]

    AFC003

    [/td]


    [td]

    LBE05CORPF

    [/td]


    [td]

    G42BE255311

    [/td]


    [/tr]


    [tr]


    [td]

    AFC003

    [/td]


    [td]

    LBE05CORPR

    [/td]


    [td]

    G42BE200051

    [/td]


    [/tr]


    [/TABLE]


    Sheet 2:

    [TABLE="width: 313"]

    [tr]


    [td]

    AFC001

    [/td]


    [td]

    LBE05ACCFB

    [/td]


    [/tr]


    [tr]


    [td]

    AFC001

    [/td]


    [td]

    LBE05ACCFX

    [/td]


    [/tr]


    [tr]


    [td]

    AFC002

    [/td]


    [td]

    LBE05CR3DB

    [/td]


    [/tr]


    [tr]


    [td]

    AFC002

    [/td]


    [td]

    LBE05CR3DX

    [/td]


    [/tr]


    [tr]


    [td]

    AFC003

    [/td]


    [td]

    LBE05CORPB

    [/td]


    [/tr]


    [/TABLE]


    Result in Sheet 3:

    [TABLE="width: 435"]

    [tr]


    [td]

    AFC001

    [/td]


    [td]

    LBE05ACCFB

    [/td]


    [td]

    G42BE200067

    [/td]


    [/tr]


    [tr]


    [td]

    AFC001

    [/td]


    [td]

    LBE05ACCFB

    [/td]


    [td]

    G42BE202067

    [/td]


    [/tr]


    [tr]


    [td]

    AFC001

    [/td]


    [td]

    LBE05ACCFB

    [/td]


    [td]

    G42BE203067

    [/td]


    [/tr]


    [tr]


    [td]

    AFC001

    [/td]


    [td]

    LBE05ACCFB

    [/td]


    [td]

    G42BE255317

    [/td]


    [/tr]


    [tr]


    [td]

    AFC001

    [/td]


    [td]

    LBE05ACCFX

    [/td]


    [td]

    G42BE200067

    [/td]


    [/tr]


    [tr]


    [td]

    AFC001

    [/td]


    [td]

    LBE05ACCFX

    [/td]


    [td]

    G42BE202067

    [/td]


    [/tr]


    [tr]


    [td]

    AFC001

    [/td]


    [td]

    LBE05ACCFX

    [/td]


    [td]

    G42BE203067

    [/td]


    [/tr]


    [tr]


    [td]

    AFC001

    [/td]


    [td]

    LBE05ACCFX

    [/td]


    [td]

    G42BE255317

    [/td]


    [/tr]


    [/TABLE]

    Re: Lookup values in a range using two or more criteria and return multiple matches


    You seem to have posted three threads with the same question? Not that you've bothered to articulate one above.

    Re: Lookup values in a range using two or more criteria and return multiple matches


    Quote from StephenR;681915

    You seem to have posted three threads with the same question? Not that you've bothered to articulate one above.



    Sorry I might be because of some technical problem.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login