Sorry...between the two sets of numbers.
--
smither fan


"Bob Phillips" wrote:

Between what?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Ross" wrote in message
...
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