INDEX (Match) Formula with contact columns

Options

Hello,

I am using an INDEX(MATCH) formula referencing 2 contact columns and it works great. However, when I try to convert to Column Fx it will not let me. Can we not change contact columns into formula columns? Or is the fact I am referencing contact columns in my formula a problem? I am not referencing partial ranges. Appreciate any insight.

Tags:

Answers