Lookup

Let me say first that I'm new here but am relatively well versed in Excel use. My current problem is hard to explain but I'll give it my best shot at being as clear as possible.

I have a worksheet (we'll call it "Blank") that is used as a form for making notes while performing an inspection. There are several fields which need to be entered and I'm trying to make it as simple as possible to fill in. Several of the fields are entered by way of drop-down menu (data validation, list). One of the drop down menus' options ("Subsystem") are dependent upon the selection in one of the other drop-downs ("System" {=INDIRECT in the source of the data validation}). All of the information for the drop down menus is on a separate worksheet (called "Matrix") within the workbook. What I would like to do is to automatically populate another cell ("Useful Life") in my worksheet "Blank" with data from "Matrix". I have a matrix set up which matches all of the available entries into "Subsystem" so that it is only a horizontal offset of a given number of cells to find the appropriate output for "Useful Life". I just don't know the syntax required to achieve this.

If it is possible to do without using VBA I would prefer it but if that is the only way to tackle it I won't rule it out entirely.

Thank you in advance for any help you can give me!

Jim

Sounds like an array formula might do it, something like

=INDEX(Matrix!Z2:Z100,MATCH(1,(Matrix!A1:A100="value1")*((Matrix!B1:B100="value2")*...,0))

adjust to suit