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!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup a reference, go to another worksheet, retrieve a block of d
Sounds like a good system.
So what's your problem? "kiwi1962" wrote: 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!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup a reference, go to another worksheet, retrieve a block
Good Point!
How do I retrieve the data block 9C x 27R from another worksheet and drop back into the work sheet with the drop down menus. I have tried an array {=IF(C29="","",INDIRECT(C29))} but have received a #REF! error Any thoughts? "Ron@Buy" wrote: Sounds like a good system. So what's your problem? "kiwi1962" wrote: 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!!! |
Reply |
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) |