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

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

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

HTH

RB
__