A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Issue returning a value from an array with using 2 criteria
Hi. I have a spreadsheet with this formula in cell W20:
=MINIFS($D:$D,$H:$H,O20)
This is returning the value in column D when the value in column H matches the value in 020 |letter o number 20|
Great. This works. I need to take this a step farther and return the value in D when column H matches 020 AND the date in column A is greater than the date in V20.
You'd think I'd be able to get this second requirement entered in the criteria range 2 and criteria 2 arguments, but it's not working. Here is what I have.
=MINIFS($D:$D,$H:$H,O20,$A:$A,>V20)
I've tried:
=IF(AND(O20=$H:$H,V20<$A:$A),$E:$E,"Not Found")
There is some issues looking in column A to see if its data is greater than the date in column V.
Please advise. Thank you.
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.