Questions on how to use match and multiple criteria to fill multiple cells

    I am using this formula but I dont know how to get it to populate more than one cell.


    Here is the formula:


    =INDEX(APPROVED!$A$3:$A$1000,MATCH($F$4&$H$1,APPROVED!$D$3:$D$1000&APPROVED!$C$3:$C$1000,0))


    It has mutiple matches but I can only see the first match in the cell.


    Thanks
    Dee :)

    Re: Questions on how to use match and multiple criteria to fill multiple cells


    Dear Deemichelle,


    How do you know , howmany match are available in List.


    So we need to create line id's with counters.


    Then if one id is having five time , we need to check first one or second one ,


    This will give the correct search.



    rb1234.01
    rb1234.02
    rb1234.03



    do the match base on any above one now.


    if you want all the match then : use advance filter in macro. you will get all the available filter in separate list.


    Regards
    S.Suresh

Participate now!

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

Register Yourself Login