| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
View, scroll and select a cell value from another Excel sheet?
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel cell alignment | Excel Worksheet Functions | |||
| Novice needs help setting up a worksheet | New Users to Excel | |||
| I cannot select a single cell or pull down cell contents | Excel Worksheet Functions | |||
| How do you control scroll rate when click and drag to select cell | Excel Discussion (Misc queries) | |||
| Cursor keys move active cell or scroll screen, how do I select whi | Excel Discussion (Misc queries) | |||
Threaded Mode
