Hi guys, i'm trying to get some results with =HLOOKUP(H6;Sheet1!$D$5:$AB$31;27;FALSE) but in the first row works fine. When i paste the formula in the next rows i get #N/A. With =IFERROR(HLOOKUP(H6;Sheet1!$D$5:$AB$31;27;FALSE);"") just hide the #N/A. Can you tell me what im doing wrong and i can get the result only in the first row? Thanks in advance.