hmltnangel
Active Member
- Joined
- Aug 25, 2010
- Messages
- 290
- Office Version
- 365
- Platform
- Windows
Afternoon all,
I have an Index Match Formula which works perfect, except for one radnom result in the middle of a calculated colum in the table.
The formula is as follows:
=IFERROR(INDEX(Sheet2!$A$1:$AX$50,MATCH([@[Age(at anticipated end date)]],Sheet2!$A$1:$A$50,0),MATCH([@[Full years of service]],Sheet2!$A$1:$AX$1,0)),"")
For one cell, this returns blank instead of the excepted result of "27" Evaluating the formula shows its not able to find teh second match in the data, but I have checked formatting etc and cant make it work. It may be that this is the farthest column along. But I just cannot figure out this simple error.
Any suggestions?
I have an Index Match Formula which works perfect, except for one radnom result in the middle of a calculated colum in the table.
The formula is as follows:
=IFERROR(INDEX(Sheet2!$A$1:$AX$50,MATCH([@[Age(at anticipated end date)]],Sheet2!$A$1:$A$50,0),MATCH([@[Full years of service]],Sheet2!$A$1:$AX$1,0)),"")
For one cell, this returns blank instead of the excepted result of "27" Evaluating the formula shows its not able to find teh second match in the data, but I have checked formatting etc and cant make it work. It may be that this is the farthest column along. But I just cannot figure out this simple error.
Any suggestions?