I'm sure there is an easy solution, but my brain (nor google it seems) can find it...
I'm trying to match two string criteria in an index match formula and I dont want to use an array.
<tbody>
</tbody>
I'd like to enter the ID and the Batch and get the Vial returned.
I'd like something like this: Index(A2:A8,Match(and("Z003",2),and(B2:B8,C2:C8),0))
And have V006 returned.
I'd prefer no arrays, is this possible? Any help is greatly appreciated!
I'm trying to match two string criteria in an index match formula and I dont want to use an array.
A | B | C | |
1 | Vial | ID | Batch |
2 | V001 | Z001 | 1 |
3 | V002 | Z002 | 1 |
4 | V003 | Z001 | 2 |
5 | V004 | Z003 | 1 |
6 | V005 | Z001 | 3 |
7 | V006 | Z003 | 2 |
8 | V007 | Z004 | 1 |
<tbody>
</tbody>
I'd like to enter the ID and the Batch and get the Vial returned.
I'd like something like this: Index(A2:A8,Match(and("Z003",2),and(B2:B8,C2:C8),0))
And have V006 returned.
I'd prefer no arrays, is this possible? Any help is greatly appreciated!