We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Aspose.Cells Formula

Hello!

I’m having trouble figuring out how to use the following formula in an Excel template using smart markers:
{=INDEX(DetailSrc!A2:K229,MATCH(1,(DetailSrc!A2:A229=A2)*(RIGHT(DetailSrc!B2:B229,2)=“12”),0),11)}

Will someone tell me what the steps are to do this? I’ve tried looking at some of the other related posts, but can’t seem to get it to work. The biggest issue seems to be the fact that the DetailSrc tab will have a variable number of rows. So far the only way I can get this to work is by hard-coding the range into the template. How do I make it dynamic?

Thanks for your help!

Hi,

Thanks for your posting and considering Aspose.Cells.

Please provide us your sample excel file having this formula in working condition so that we could experiment with it and update you with a sample code to achieve your requirement. You can also create your formula manually using Microsoft Excel. Also this formula looks like an Array Formula, it will be helpful if you also let us know the steps you took in Microsoft Excel to create it. Thanks for your cooperation.