cancel
Showing results for 
Search instead for 
Did you mean: 

Alternative to Match and Lookup

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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.

Former Member
0 Kudos

You should be able to use VLOOKUP/HLOOKUP or ideally INDEX.

Hope that helps.