Advanced Filter/Index Match Help

  • Hi Guys,


    Say I have values A2:A18 on sheet 1, and a whole other sheet full of data.
    How can I search my values ofA2:A18 in my other sheet and return the entire rows where this values exist?

    Having trouble with using index match formula and/or advanced filtering.
    Any help on how to do either or both would be appreciated.



  • Re: Advanced Filter/Index Match Help


    On "the other sheet", are you searching a single column, or could the value be in any column?

    Best Regards,
    Luke M
    =======
    "A little knowledge is a dangerous thing."

Participate now!

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