software

I have a list of sales invoices in column B with a associated sales territory
in column A. Can vlookup display more than one invoice #. If so, how?

Mark

On Mon, 15 May 2006 14:18:01 -0700, Mark
gt; wrote:

gt;I have a list of sales invoices in column B with a associated sales territory
gt;in column A. Can vlookup display more than one invoice #. If so, how?
gt;
gt;Mark

No. You probably need to filter the data - either in place or copy
somewhere else.

HTH

RB
__

Hi,

Assuming your data is arranged in range A1:B7 like this

Ashish100
Sanjay200
Pongal300
Ashish400
Rajesh500
Suresh600
Ashish700

In cell A10 enter any of the names mentioned in range A1:A7. In cell B10,
enter the following array formula (Ctrl Shift Enter)

=IF(ISERROR(INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$ 10,ROW($A$1:$A$7)),ROW(1:1)),2)),quot;quot;,INDEX($A$1:$B$ 7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1 )),2))

Copy this formula down.

Please let me know if you need any more clarifications on this
). Will be more then willing to help you

Regards,

Ashish Mathur

quot;Markquot; wrote:

gt; I have a list of sales invoices in column B with a associated sales territory
gt; in column A. Can vlookup display more than one invoice #. If so, how?
gt;
gt; Mark