Can a dropdown box reference to another workbook?

  • Thread starter Thread starter Megtastic
  • Start date Start date
M

Megtastic

I am trying to create a dropdown list that will refernce to another workbook
where i will have a parts list, so that i can then use VLOOKUP to give me
details such as prices/part numbers. Is this possible to do?
 
Select the parts list on the other sheet and name it using the name box.

On the VLOOKUP sheet install your data valadation using List and in the
Source box enter =YourListName.

HTH
Regards,
Howard
 
Woops... My bad. I read another worksheet instead of workbook.

A named range will not work from another workbook as far as I tested it.

Sorry.

Regards,
Howard
 
From a Google search...read line six.

Hi


With validation list, only cell references to same
worksheet are allowed.
To refer to list on another worksheet in same workbook,
you have to define
the list as named range (Insert.Name.Define...)
To refer to list in another workbook, the safest way will
be mirroring it
into some sheet (links or ODBC query), define the
mirrored list as named
range, and refer to named range as list source.


--
Arvi Laanemets

HTH

Regards,

Howard
 
Back
Top