Hello,
I have a problem to get the formula work.
Column G Column H Column I
Product
Salesman
Units Sold
Fax
Brown
1
Phone
Smith
10
Fax
Jones
20
Fax
Smith
30
Phone
Jones
40
PC
Smith
50
Fax
Brown
60
Phone
Davis
70
PC
Jones
80
Fax
Jones
Err:504
The formula is =INDEX(I2:I10;MATCH(1;(G12=$G$2:$G$10)*(H12=$H$2:$H$10);0)).
Using Ctrl, Shift + Enter. Please help.
Regards,
Lawrence Low
(+65) 6539-1870 (O)
(+65) 9203-1017 (P)
*********************************************************************************
The most effective way to achieve right relations with any
living thing is to look for the best in it, and then help that
best into the fullest expression.
*Allen J. Boone {American Author}
*********************************************************************************
This transmission has been issued by a member of the UOB Kay Hian Group for the
information of the addressee only and should not be reproduced and/or
distributed to any other person. Each page attached hereto must be read in
conjunction with any disclaimer which forms part of it. Unless otherwise
stated, this transmission is neither an offer nor the solicitation of an offer
to sell or purchase any investment. Its comments are based on information
obtained from sources believed to be reliable but UOB Kay Hian Group makes no
representations and accepts no responsibility or liability as to its
completeness or accuracy.
