What formula to search for info from another workbook

[ravihotwok]

HEllo

im making a spreadsheet to look up different car part prices for different car. What i am trying to do is this,

i have a cell called make which has a drop down list of car makes. I have another one called model which depending on what make you choose will populate a drop down list with relevant models. For example if you select ford from the make list then you will have a list in the make cell with fiesta, escort, modeo etc etc. In the next cell is a drop down list of different car part suppliers. I can do all this but this next bit is where im stuck. I have another cell with the heading parts, once you have selected the car make, model and the parts supplier you want, I want the cell to be popluated with a drop down menu with all the parts avaliable for that car by that supplier.

The info for each supplier will be stored in a seperate work book to save file size

Can this be done?

[ravihotwok]

Any help would be most appreciated, thanks

[NBVC]

Have a look at Dependent Lists