| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup a reference, go to another worksheet, retrieve a block of d
I am working on a planned maintenance costing system where we identify make
and model of machines via data validation. eg Ford and Mustang. These are concantenated together in one cell as Ford Mustang. Using this cell information search another worksheet for a block of data that relates to Ford Mustang and return to original work sheet. This is to allow sales staff to select a make/ model from the drop down lists and finalise a quote for customers using the data pulled in from the lookup search. Thanks in advance!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to reference a block of cells from another sheet. | New Users to Excel | |||
| I NEED TO USE A LOOKUP FUNCT. TO RETRIEVE A PICTURE FROM A HYPERL | Excel Worksheet Functions | |||
| Can I insert a cell reference into a block of text? | Excel Discussion (Misc queries) | |||
| How to use lookup to retrieve next LARGEST value? | Excel Worksheet Functions | |||
| need to retrieve dates from lookup | Excel Discussion (Misc queries) | |||
Threaded Mode
