Forum Discussion

A819A1L's avatar
A819A1L
Brass Contributor
Jan 31, 2020

VLOOKUP with multiple criteria (trying to work around SPILL error)

Hi. I really need help with the SPILL error. I know it's been an issue since the update last year and the solution is to select a specified range rather than an entire column, but the result only par...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jan 31, 2020

A819A1L 

If your Excel version allows it, this one will work:

=TEXTJOIN(", ",,UNIQUE(IFERROR(INDEX(J:J,IFERROR(1/(B55=$H$2:$H$103)*ROW($H$2:$H$103),""),1),"")))

 

  • A819A1L's avatar
    A819A1L
    Brass Contributor
    Jan 31, 2020
    Spoiler
    It works on bringing the text together however, the results are incorrect as I'm trying to separate the resource criteria i.e. return the operator to the associated machine.

Resources