Forum Discussion
Solved
hlookup help - structured reference
Hi there, So I am working on a problem where I am stumped with hlookup... the prompt asks me to: In cell E2, enter a formula using the HLOOKUP function as follows to determine a student's pot...
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)
I tried to fill the formula into the range E3:E31, but it says #N/A. Now I don't know what to do.