can I have my 3 column table on another worksheet
within the same workbook?

Yes, but that will require some changes.

Assume the lookup table is on Sheet2.

A1, B1 and C1 are the column headers.

The actual table data is in the range A2:C20.

Goto InsertNameDefine
Names in workbook: Parts (or whatever you want to call it but Parts seems
self explanatory to me!)
Refers to:

=OFFSET(Sheet2!$A$2,MATCH(Sheet1!$A$2,Sheet2!$A$2: $A$20,0)-1,1,COUNTIF(Sheet2!$A$2:$A$20,Sheet1!$A$2))

OK out

Then select cell B2 on Sheet1 (the dependent drop down)
Goto DataValidation
In the Source box, delete the formula that is currently entered and replace
it with this:

=Parts

OK out

This is all necessary because Excel doesn't "like" it when you use
validation that is located on a different sheet!

Biff

"Intuit" wrote in
message ...

Great! I think that example will help. I think I understand what you
put in, but can I have my 3 column table on another worksheet within
the same workbook?


--
Intuit
------------------------------------------------------------------------
Intuit's Profile:
http://www.excelforum.com/member.php...o&userid=30901
View this thread: http://www.excelforum.com/showthread...hreadid=507298