Hello
I have a formula which is used to create a unique list. It works fine except I'd like to expand it.
IFERROR(INDEX(Banks!$N$31:$N$3500, MATCH(0, COUNTIF($A$10:$A10,Banks!$N$31:$N$3500)+(Banks!$H$31:$H$3500<>$V$2)+(Banks!$L$31:$L$3500<>$A$10), 0)),"-")
I'd like to change the part $V$2 so it refers to a range instead like $V$2:$V$12.
Can anyone suggest how this is possible?
Bookmarks