Approximate Match from Multiple Columns

[Gos-C]

Hi, all.

I need your help, please.

I have a range of numbers in 3 columns: Column A has groups of repeated numbers representing a quantity (e.g., 1 is listed 5 times, 50 is listed 5 times, 100 is listed 5 times etc.). Column B has 1, 4, 6, 8, 10 representing the number of ingredients associated with the quantity. Column C has an allowable time for each combination of quantity (Column A) and number of ingredients (Column B).

I need to match E2 and F2 with A and B, respectively and return the value in Column C - please see attached sheet.

(I am using Excel 2016 - for work.)

 

[Fluff]

How about

=INDEX(C:C,AGGREGATE(14,6,ROW(A2:A56)/(A2:A56<=E2)/(B2:B56<=F2),1))

 

[Gos-C]

How about

=INDEX(C:C,AGGREGATE(14,6,ROW(A2:A56)/(A2:A56<=E2)/(B2:B56<=F2),1))

Hi, Fluff. Yes, that works perfectly. Thank you very much.

 

[Fluff]

You're welcome & thanks for the feedback.