See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP

On Mon, 21 May 2007 14:11:14 -0700, "Bruce" wrote:

I am creating an invoice. The data is to be pulled from a worksheet called
"DATA".
There is one row for each item. There may be several items per invoice. Each
are keyed with the "InvoiceNum" columnBA
On my invoice, I have named fields that represent each item on a row. But I
am not sure how to get the other items that are tied to the same invoice
number. There are only 2 cells that are needed and these are item and rate
(columns AU and AV)

Any ideas on how to do this?

I am using the example I D/L from http://j-walk.com/ss/excel/tips/tip92.htm
as my base.

Thanks
Bruce