Forum Discussion

Excel's avatar
Excel
Iron Contributor
Jul 21, 2022
Solved

Query related to Exact value

Hello Everyone, 

 

I was trying to make a calculation sheet but stuck at one point. I want to compare two values (eg. 110.43 & 40) with values from another columns in a table and return a value corresponding to next higher number of 110.43 and exact match of 40

 

 I want to return 150 and in a cell if I have a value of 110.43and 40 by comparing it with Inner Dia and Schedule. Another example from table If I have a value of 76 and 80 hen it should return as answer corresponding to numbers 97.18 and 80..

 

Please help..

 

 

Here is attached file..

  • Excel 

    Does this do what you want?

     

    =IFERROR(INDEX($D$3:$D$21,MATCH(1,($A$3:$A$21>=F7)*($C$3:$C$21=G7),0)),"")

     

    If you don't have Microsoft 365 or Office 2021, confirm with Ctrl+Shift+Enter.

  • Excel 

    Does this do what you want?

     

    =IFERROR(INDEX($D$3:$D$21,MATCH(1,($A$3:$A$21>=F7)*($C$3:$C$21=G7),0)),"")

     

    If you don't have Microsoft 365 or Office 2021, confirm with Ctrl+Shift+Enter.

Resources