Share via

Issue returning a value from an array with using 2 criteria

Anonymous
2024-04-11T02:49:57+00:00

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.

0 comments No comments