Match(1,(xxxxxx)*(xxxxxxx),0) = why 1 and not 2 or 3 ...

It's because the lookup array in the MATCH, this part:
(A1:A100="Custname")*(D1:D100="State")
will resolve to an array of ones/zeros, eg: {0;0;1;0;0;0;0;...}
depending on where the dual criteria is satisfied (1's) or not (0's)

Using the lookup value: 1 in MATCH would hence give us the (1st) matching
position within the array where the dual criteria is satisfied. It's presumed
of course, that there should be only a single matching position (ie a
single/unique instance of 1) to be returned within the array. That position
(a number) returned is then used by the INDEX part of the expression (eg:
INDEX(F1:F100, ...) to yield the required result.

Hope the above clarifies it.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---