Combine two excel sheets

[MADAI96]

Hello,

I am using jquery calx to add some formulas that I have inside a table, my formula in Excel is the following:

=SI(N3="BLK";BUSCARV(M3;'RC'!J:M;4;FALSO);BUSCARV(M3;'RC'!J:M;3;FALSO))

Hello,

I am using jquery calx to add some formulas that I have inside a table, my formula is the following:

=IF(N3="BLK";VLOOKUP(M3;'RC'!J:M;4;FALSE);VLOOKUP(M3;'RC'!J:M;3;FALSE))

Which the word RC is my second excel sheet and therefore when putting it as in the examples of jquery calx it marks an #ERROR, I have the following syntax using razor syntax in c # mvc:

`
@Html.DisplayFor(modelItem => item.ACTUALaxemty)

` My script is:

`@section scripts
{
<script src="~/Scripts/jquery-calx-2.2.7.js"></script>
<script src="~/Scripts/jquery-calx-2.2.7.min.js"></script>
<script src="~/Scripts/jquery-calx-sample-2.2.7.min.js"></script>
<script src="~/Scripts/numeral.min.js"></script>
<script src="~/Scripts/numeric.min.js"></script>

<script type="text/javascript">
    $('#TablaEnrut').calx();
    $('#RC').calx();
</script>

}`

I would appreciate if someone had a similar error, could support me or guide me.

Thanks.

[ikhsan017]

Hi @MADAI96, to make 2 sheets work together, you need to initialize it like $('#sheet_1, #sheet_2').calx(), instead of initializing it independently

[MADAI96]

Hello @ikhsan017

Regarding your answer, I already tried the way to combine both sheets.

In my first table my formula is:

<td class="text-center" data-formula='CONCAT(VLOOKUP(M3;"#TablaRC!J:K;2;FALSE"))'>@Html.DisplayFor(modelItem => item.actual17)</td>

Additional call jquery calx:

<script type="text/javascript"> $('#TablaEnrut, #TablaRC').calx(); </script>

In my second table, which is tablaRC, I call it:

<script type="text/javascript"> $('#TablaRC').calx(); </script>

And both tables contain information, but my result in my column is: #N/A!

Additionally I wonder if there is a newer version of jquery calx.

Best regards.