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?