Could someone help me, I have hlookup formula returning value 0 if in sheet years in no value.
Thank in advanced

Attached Files

Example.xlsx (10.1 KB, 11 views)

Your formula does not return an error when the cell is empty, it is the same as 0
Perhaps like this ?

=IFERROR(IF((HLOOKUP(A2,years!A$1:F$5,2,0))=0,"",H LOOKUP(A2,years!A$1:F$5,2;0)),"")


( the space between H and LOOKUP is added by the board. Disregard it)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Since your return values are text, you can also use:

=IFERROR(HLOOKUP(A3,years!A$1:F$5,2,0)&"","")