ehardway123
New Member
- Joined
- May 24, 2013
- Messages
- 22
Hey all,
I am not sure what is happening. I have used this function a bunch of times and it is giving me a #na. My function is =HLOOKUP(D2,BL!$A$4:$D$17, MATCH(Sheet6!$C$1,BL!$A$4:$A$16,0), FALSE). D2 is 13 and c1 is JUN. It should be returning the number 5 but it is giving me an #n/A. What am i doing wrong? Below is the table im trying to return the number from.
<colgroup><col span="2"><col><col><col></colgroup><tbody>
</tbody>
I am not sure what is happening. I have used this function a bunch of times and it is giving me a #na. My function is =HLOOKUP(D2,BL!$A$4:$D$17, MATCH(Sheet6!$C$1,BL!$A$4:$A$16,0), FALSE). D2 is 13 and c1 is JUN. It should be returning the number 5 but it is giving me an #n/A. What am i doing wrong? Below is the table im trying to return the number from.
WLTYPE | BL | |||
Count of WLTYPE | Column Labels | |||
Row Labels | 13 | 14 | 15 | Grand Total |
JAN | 11 | 20 | 31 | |
FEB | 5 | 23 | 28 | |
MAR | 6 | 13 | 19 | |
APR | 7 | 10 | 17 | |
MAY | 20 | 3 | 23 | |
JUN | 5 | 15 | 20 | |
JUL | 8 | 13 | 21 | |
AUG | 15 | 16 | 31 | |
SEPT | 2 | 17 | 19 | |
OCT | 6 | 6 | 12 | |
NOV | 1 | 26 | 27 | |
DEC | 1 | 13 | 14 | |
Grand Total | 65 | 141 | 56 | 262 |
<colgroup><col span="2"><col><col><col></colgroup><tbody>
</tbody>