LauraEdson10
New Member
- Joined
- Apr 10, 2018
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
Hello,
I have a spreadsheet where I'm wanting to input the "Make", "Model", "Mast Type" and "Lift Height" and from this information, look up data in another tab and insert into my first sheet but with there being multiple criteria, I'm struggling to work it out.
For example, with the "Engine Spec", this is dependant upon the Make and Model of truck but if another model is entered, cell should be blank.
With the "Mast Spec", once the Model, Mast Type AND Lift Height has been entered onto the first tab, it should be able to look up the rest of the information.
I have only entered part of the Engine Spec and Mast Spec so although may seem simple, there are hundreds of variations depending upon what is entered into the first 4 cells B1:B4 but I'm hoping I can then apply the formula to the rest of the info too.
Any assistance would be appreciated.
Thank you.
I have a spreadsheet where I'm wanting to input the "Make", "Model", "Mast Type" and "Lift Height" and from this information, look up data in another tab and insert into my first sheet but with there being multiple criteria, I'm struggling to work it out.
For example, with the "Engine Spec", this is dependant upon the Make and Model of truck but if another model is entered, cell should be blank.
With the "Mast Spec", once the Model, Mast Type AND Lift Height has been entered onto the first tab, it should be able to look up the rest of the information.
I have only entered part of the Engine Spec and Mast Spec so although may seem simple, there are hundreds of variations depending upon what is entered into the first 4 cells B1:B4 but I'm hoping I can then apply the formula to the rest of the info too.
Any assistance would be appreciated.
Thank you.
