Forum Discussion
index match duplicates problem
playing with index match to learn excel, (match a & b and display all columns of rows that match) running into issues with search results , seems to find a match on say row4 and display, then...
Hello,
Google and Excel are different products. Excel does not have an ARRAYFORMULA function. If you work with Excel, please stick to Excel. If you prefer to work with Google sheets, by all means, do so, but be aware of the differences.