Match

[jebenexcel]

Hi,

Why am I getting 48 here instead of 12?

Formula:

=MATCH(0;D58:AY58;1)

This is the 58th row:

 

[ORoxo]

If you dont have a 0 in column D, that's why.

You have the last parameter set as 1, that means approximate value. Try to change it to 0 and see if it works.

 

[jebenexcel]

Now I get 13 even in rows that don't have 0s there yet...
The first 12 columns are copied over as values, the others are references to a pivot table.
Before, it was just a pivot table and it worked but that option is not possible anymore...

 

[ORoxo]

I tried using a dataset as you have and it worked.

Do you have the calculations set to manual by any chance?