Forum Discussion
hlookup help - structured reference
1) In the formula the lookup value is entire column. Formula returns spill (an array) for which there is no place in one cell of the table, thus an error. Change on the value from current row reference.
2) Lookup range has only two columns, and you try to return the result from row 14. Thus #REF error, since there are no so many rows in the range. Change on 2.
Finally
=HLOOKUP([@[Post-Secondary Years]],$P$13:$U$14,2,TRUE)
1) In the formula the lookup value is entire column. Formula returns spill (an array) for which there is no place in one cell of the table, thus an error. Change on the value from current row reference.
2) Lookup range has only two columns, and you try to return the result from row 14. Thus #REF error, since there are no so many rows in the range. Change on 2.
Finally
=HLOOKUP([@[Post-Secondary Years]],$P$13:$U$14,2,TRUE)
In this formula
=HLOOKUP([Post-Secondary Years],P13:U14,2,TRUE)you reference entire column [Post-Secondary Years], thus HLOOKUP return the spill for which there is no space within table. Thus #SPILL! error.
Perhaps you'd like to hlookup value in current row, when it shall be
=HLOOKUP( [@[Post-Secondary Years]],P13:U14,2,TRUE)