Skip to Content
0
Former Member
May 11, 2010 at 08:12 AM

Unsupported formula

30 Views

Hi all.

I'm currently working on a Xcelsius project where I have included a fomula to extend the VLOOKUP functionality. The formula makes VLOOKUP return all instances of the criteria given, from the range table.

It looks like this:

=IF(ISERROR(INDEX($A$1:$H$137;SMALL(IF($A$1:$A$137=$J$39;ROW($A$1:$A$137));ROW(1:1));2));"";INDEX($A$1:$H$137;SMALL(IF($A$1:$A$137=$J$39;ROW($A$1:$A$137));ROW(1:1));2))

The formula looks in a range, returns the row number, then returns the value from the column specified. The formula works as expected in the Xcelsius spreadsheet, but when generating preview, Xcelsius says ROW formula is not supported - and the desired functionality does not appear in the preview.

I have checked documentation for supported Excel formulas, and all formulas used is listed as supported.

Any hints on how to handle this? Or how to make a workaround to achieve the same functionality?

Thanks.

Best regards,

Runar Wigestrand.