Interpretation for:
=INDEX(F1:F100,MATCH(1,(A1:A100="Custname")*(D1:D1 00="State"),0)) Enter with
Ctrl+Shift+Enter

Dear All,

I came across this formula and was wondering how to interpret:

Match(1,(xxxxxx)*(xxxxxxx) = why 1 and not 2 or 3 or so forth (i tried 2 and
3 but doesn't work)


I tested the formula in my workbook

=INDEX(Dbase!B1:B22,MATCH(1,(Dbase!C1:C22=B1)*(Dba se!A1:A22=B2),0)) = works

=INDEX(Dbase!B1:B22,MATCH(2,(Dbase!C1:C22=B1)*(Dba se!A1:A22=B2),0)) =
doesn't work


Thanks.