0

On Column B I'm trying to get a TEXTJOIN with delimiter "," of INDEX MATCH to the price range you see on Table B. Because cell A5 contains "Apple" then "$$$" is one of the values I need, also A6 contains "Banana" then "$$" is the second value i need. Finally cell A7 contains "Pineapple" but because "$$$" is already was selected because of apple then no need to add it again.

enter image description here

Kobe2424
  • 147
  • 7
  • just replace the FILERXML part from your last question with the range: `=TEXTJOIN(",", 1, UNIQUE( XLOOKUP( [Fruits],TableB[Fruit], TableB[Price Range],"",0)))` – Scott Craner Oct 05 '21 at 16:01
  • Works. Thank you! good eyes on noticing my previous question as well – Kobe2424 Oct 05 '21 at 19:06

0 Answers0