ROW(586) is the invalid part.
Which cell is the formula in?
however I suspect there is a better method of doing this with index and match, What exactly is the formula doing ( in english )?
Indirect is an equation only to be used when there is no other solution, it's very slow.