Hi,
I am trying to pull a specific value from inside of a table utilizing an Index & Match formula, but I am encountering an error when I reference the table headers to identify the column number. I attempted to break down my formula to identify where the problem is occurring and found something that has me utterly confused.
Here is a sample of the table I am working with. The table name is TBL_Increases:
<tbody>
</tbody>
Here are my reference values:
<tbody>
</tbody>
The formula I am using is:
=INDEX(TBL_Increases,MATCH(A1,TBL_Increases[Industry],0),MATCH(B1,TBL_Increases[#Headers],0))
The formula returns with an #N/A error.
After further examination, the second MATCH formula (for the column header number) is returning with the error. So I tried a simple =B1=C2 to see if the values are the same, but it came back as FALSE.
Can someone help me understand this?
I am trying to pull a specific value from inside of a table utilizing an Index & Match formula, but I am encountering an error when I reference the table headers to identify the column number. I attempted to break down my formula to identify where the problem is occurring and found something that has me utterly confused.
Here is a sample of the table I am working with. The table name is TBL_Increases:
A | B | C | D | |
1 | Industry | 2015 | 2016 | 2017 |
2 | Energy | 0.5 | 2.5 | 3.0 |
3 | Financial | 3.0 | 2.9 | 3.1 |
4 | Healthcare | 3.0 | 3.0 | 3.4 |
<tbody>
</tbody>
Here are my reference values:
A | B | |
1 | Energy | 2016 |
<tbody>
</tbody>
The formula I am using is:
=INDEX(TBL_Increases,MATCH(A1,TBL_Increases[Industry],0),MATCH(B1,TBL_Increases[#Headers],0))
The formula returns with an #N/A error.
After further examination, the second MATCH formula (for the column header number) is returning with the error. So I tried a simple =B1=C2 to see if the values are the same, but it came back as FALSE.
Can someone help me understand this?