Forum Discussion
Can you use AND / OR in an INDEX MATCH
Hi I have am array formula that looks like this: =INDEX('Rebate report'!A:A,MATCH(1,('Rebate report'!A:A=A2)*('Rebate report'!B:B=B2)*('Rebate report'!C:C=C2),0),1) which works. I want to add...
Which version of Excel do you have?
No, I don't have a test workbook, sorry.
I am not sure why we are working at the back end of a 5 year old discussion. Wouldn't a fresh discussion with less legacy discussion be better?
Did you put together any test workbooks? Having something to work on would help.
My immediate thoughts lean towards FILTER/VSTACK/SORT but it would be nice to see an example.
That's good, because it has functions suitable for that such as VSTACK. But unfortunately, I don't have 365, so I'm tagging a few of my friends:
