on 05-11-2010 9:12 AM
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Excel supports formulas only for small data set's If you wanna show that on to the dashboard.However Xcelsius Support
Sumif,Countif,Hlookup,Vlookup .But not the formulae what you had written.
Please take out the SMALL from the formulea you have written.And try this..I will give you the error ,Till you remove the SMALL.
Any concerns write to me.
Thanks&Regards,
satish.p
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.