Return an answer if 4 conditions are satisfied

First I'd start off by cleaning your Data and Lookup tables.

Some have trailing space, some don't. Causing issue with straight forward Aggregate/Match.

Ex: 316L Stainless Steel in row 1 of Core Material has no trailing space, but the second row has one.

Same goes for all other areas of your workbook.

Also, row# of Table [Micron Rating] is different from all other tables in the Data sheet. You should match the dimension. Otherwise, it will be tricky to use formula.

When the clean up is done, you can use INDEX(LookupRange,Match(Cond1&"-"&Cond2&"-"&Cond3&"-"&Cond4,Range1&"-"&Range2&"-"&Range3&"-"&Ranage4,0) array formula.

However, note that you have text value in B18, but numeric in [Length (in)], and will need to convert B18 to numeric first before you can match.

Using Aggregate function in place of MATCH (so that you don't have to use CTRL + SHIFT + ENTER to confirm formula) and assuming that you've done above clean up... something like below.

Formula:

Please Login or Register  to view this content.

You are welcome

If you are satisfied with solution(s) provided, please mark the thread as solved. Using Thread tools found at top of your initial post.