Forum Discussion

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...

Schedule.xlsx16 KB

excel

A819A1L

Brass Contributor

Jan 31, 2020

Haytham Amairah Yes, the second one works! Thank You!

Any ideas on how to concatenate the names together?

Abi

SergeiBaklan

Diamond Contributor

Jan 31, 2020

A819A1L

Another variant

=TEXTJOIN(", ",1,UNIQUE(FILTER(J:J,(G:G=$A2)*(H:H=$B2),"")))

Schedule (1).xlsx27 KB

A819A1L
Brass Contributor
Jan 31, 2020
SergeiBaklan

Thanks. This formula works best.
- SergeiBaklan
  Diamond Contributor
  Jan 31, 2020
  A819A1L
  
  You are welcome, thank you the confirmation.
Riny_van_Eekelen
Platinum Contributor
Jan 31, 2020
SergeiBaklan
See now that my formula only looks at JobNum. So it will go wrong if you have the same JobNum occurs with multiple Resources. Since this is the case, my solution is useless. But it was fun to create it.