on 04-26-2011 9:22 PM
Is there a function other than MATCH or LOOKUP function that works correctly in both design mode and preview mode? I have noticed that both functions operate backwards in design mode, but work correctly in preview mode.
I need both design mode and preview mode to show the same thing for a result.
Hi,
Xcelsius doesn't support all excel functions but we have a previlage to add some fuctions
www.youtube.com/watch?v=JG_UY5Y5QOw
that video shows you how to develop your own Xcelsius Excel Functions.
Let me know if you have any issues.
Regards,
AnjaniKumar C.A.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You should be able to use VLOOKUP/HLOOKUP or ideally INDEX.
Hope that helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.