Need help to choose the right function.

[Bahjat_Haddad]

Hi,

Can someone please advise how to get around this. I have two inputs as shown in the attached photo, in red and green. What kind of function that would return a value i.e. orifice size, from the very first left column based on these two inputs?

in the example below the function should start by looking for a value of 100 in the first row of the array which is in this example (3rd column in the array here) and then search in that column to find 9, then returns 12.7 from the first column

Thanks

[#2 · Accepted solution]

@Bahjat_Haddad Use SUMPRODUCT() function.

=SUMPRODUCT((A2:A4)*(B2:D4=C9)*(B1:D1=C8))

[#3]

@Harun24HR Thanks a lot

[#4]

If you find it useful then please tick mark it as best response.

[#5]

@Harun24HR One more question please, if the value in cell C9 is 7 instead of 9, how can I write the equation so it can go automatically to the next higher value i.e. 9?

[#6]

Then we have to use >= or <= operators.

[#7]

I actually had tried before posting my question but didn't work for me, always showed zero. Could you please demonstrate? Thanks