0

I'm having some issues with the new excel release and an old Excel file with "=Index(Match(...))" formulas.

In the new version of excel, it's automatically writing "@" before the formula. "=@Index(Match(...))". I have a couple of questions:

  1. Do you know what does it do? or what is that for?
  2. Do you know how to remove them?

In some of the formulas I want Na() as a result, but it replaces the result by zeros... In previous versions of excel it is working.

Miguel Fabra
  • 53
  • 3
  • 11
  • Are you sure the cell format is general? – Andreas Nov 21 '19 at 16:44
  • 1
    It should mean that the formula is relying on *implicit intersection* to return the relevant result - e.g. if you used an entire column for the lookup values (1st argument to MATCH). – Rory Nov 21 '19 at 16:48
  • 1
    [Here](https://stackoverflow.com/q/58534445/9758194) you can find some information on what it does. – JvdV Nov 21 '19 at 16:54

0 Answers0