Hello,
I've been searching for possible solutions to this particular problem for an hour (seems like every time I solve one thing, I break five others).
What I'm trying to do:
I need to search a report based on two values (for an example lets say 4 and D). They are in two separate columns on the report page. I need to return the value in a third column based on these two criterias. I need to return only the first value in the third column.
For Example:
This is the report
<TBODY>
</TBODY>
So I need to find the first 4 & D combo and only return the 40.00 that is in the third column. Currently I have a SUMIFS as the formula.
But this pulls back 40.00 + 5.00 and returns 45.00. Is there another formula that will allow me to search by both criteria but return the first matching value?
Thank you,
-Alex
I've been searching for possible solutions to this particular problem for an hour (seems like every time I solve one thing, I break five others).
What I'm trying to do:
I need to search a report based on two values (for an example lets say 4 and D). They are in two separate columns on the report page. I need to return the value in a third column based on these two criterias. I need to return only the first value in the third column.
For Example:
This is the report
1 | 10.00 | |
2 | A | 20.00 |
2 | A | 25.00 |
4 | 0.00 | |
4 | D | 40.00 |
4 | D | 5.00 |
<TBODY>
</TBODY>
So I need to find the first 4 & D combo and only return the 40.00 that is in the third column. Currently I have a SUMIFS as the formula.
Code:
=SUMIFS(TB!$F:$F,TB!$A:$A,'Source '!B5,TB!$B:$B,'Source '!C5)
But this pulls back 40.00 + 5.00 and returns 45.00. Is there another formula that will allow me to search by both criteria but return the first matching value?
Thank you,
-Alex