I have 5 columns of data and I’m using an INDEX/MATCH function to pull data from column 5 based on exact criteria matches from columns 1, 3 & 4. So basically the user chooses 3 different criteria (from dropdowns) and if all three match columns 1, 3 & 4 exactly then the result(s) comes from column 5.
Here’s the function I’m using…