Forum Discussion
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 cor...
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.
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.
- Thank you so much sir
