Gord - Many thanks for your suggestion.
I will explopre this option.

Regards
Matt



Gord Dibben wrote:
Use a ComboBox in conjunction with a Data Validation dropdown.

This will give you autocomplete for the DV list.

See Debra Dalgleish's site for instructions and a sample workbook.

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

After setting up the DV/combobox you can go ahead and set up your VLOOKUP
formulas.

Gord Dibben MS Excel MVP

Hi everyone.
I am trying to create a reference sheet where people can search for a
[quoted text clipped - 14 lines]
Kind regards
Matt

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200912/1