View, scroll and select a cell value from another Excel sheet?

[benb]

I have created an estimating spreadsheet. It looks to other excel data files
for data imported from our business system (Stock file, Customer file) At the
moment I use VLOOKUP to lookup values after the user types in a code for the
stock or customer. My users have a hard copy of the stock and customer lists
so they can find the exact code they need to enter.
I would like the ability to search the data file to select the code to be
used - from within the active cell in my estimate sheet. Then use VLOOKUP to
complete the result.
How can this be done?

 

[Roger Govier]

Hi

If I have understood your requirement, you need a dropdown for the user
to select the code.
Take a look at Debra Dalgleish's site on Data Validation and you will
see lots of ways of achieving this.
http://www.contextures.com/xlDataVal01.html