Hello. Is there a way to use the MATCH function to use both of 2 criteria values from the same range - they will be mutually exclusive on a line by line basis in the array being queried?
There are other criteria from different ranges to be used in conjunction with this.
MATCH function
-
HansV
- Administrator
- Posts: 79321
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: MATCH function
Welcome to Eileen's Lounge!
Yes, you can:
=MATCH(1, (condition1)+(condition2), 0)
If you need more help, please provide more detailed and specific information.
Yes, you can:
=MATCH(1, (condition1)+(condition2), 0)
If you need more help, please provide more detailed and specific information.
Best wishes,
Hans
Hans