Lookup a reference, go to another worksheet, retrieve a block of d

K

kiwi1962

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!!!
 
K

kiwi1962

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference a cell to a worksheet?????????? 6
Linking value of cell on one worksheet to a column on another work 1
Duplicating a cell from one worksheet to another worksheet 1
limit the list of a combo box based on the result of another 5
limit the choice of a combo box based on the choice of another 3
Lookup values if Value 1 is x or y and Value 2 is a,b,c,d. 3
How do I reference a cell to another in the preceding worksheet 8
How to creat a reference to a cell in another worksheet and keep f 5

Top