Lookup 2 values
Hi Bob,
Would this formula also give a space between?
--
smither fan
"Bob Phillips" wrote:
=INDEX(C1:C100,MATCH(1,(A1:A100=acc_no)*(B 1:B100=sub_acc_no),0))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Jaleel" wrote in message
...
Can anybody help me with a formula to lookup 2 values simultaneously like
Account No. and Sub Account No.?
Thanks in advance.
Jaleel
|