-
Re: How do I combine multiple INDEX Collect formulas in one Formular?
Looks like your #Unparseable error may be due to this extra comma with no parameter to follow. Remove it completely or add a column number for the Index function.1 · -
Re: Unique codes
The challenge with VLOOKUP is it specifies a column number. If you change the column order or add a column to the reference sheet, it could throw off your formula and return incorrect information.1 ·