Hi all,
I currently have an issue trying to produce a list of text based upon multiple criteria from a large table.
I have a working solution based upon a single criteria, which is an array as follows:
{=IF(ISERROR(INDEX(Complete!$A$2:$J$200,(SMALL(IF(Complete!$A$2:$A$200=$V$6,ROW(Complete!$A$2:$J$200)),ROW(1:1)))-1,3)),"",INDEX(Complete!$A$2:$J$200,(SMALL(IF(Complete!$A$2:$A$200=$V$6,ROW(Complete!$A$2:$J$200)),ROW(1:1)))-1,3))}
This returns the text value in column 3 for each match in column a of the value in v6
The issue i have is I want to do the same as above but only for when it match both column a to v6 AND column b to v7
I have tried playing with the IF function but cant seem to land on the right formula to get things to work, can anybody suggest how to edit this please?
Regards
Jkaen
Bookmarks