When activating "Colum formulas" the Cross sheet references become "invalid ref"

Francis Dupuis

When activating "Colum formulas" the Cross sheet references become "invalid reference".

 The Cross sheet references to a big sheet.

Mark Cronk

Hi @Francis Dupuis ,

Did the formula work before you converted it to a Colum Formula? Did all of the cells in the Column have the same formula? If the answer to both of those questions is yes, it would help to see your formula. Please attach a screenshot and/or your formula.

Happy to help.

Mark

Francis Dupuis

Hi, the answer to both is yes, here is the formula : =VLOOKUP([Courriel employé]@row; {1.1-Embauches}; 2; false).

It is a simple formula.

Mark Cronk

Your formula looks good. Invalid reference errors occur when a reference name to another sheet (in curly braces) doesn’t exist as a reference to another sheet. To resolve it try creating a new reference and using a different name.

To avoid the #No Match, add IFERROR to your formula =IFERROR(VLOOKUP([Courriel employé]@row; {1.1-Embauches}; 2; false),"")

Mark