=HLOOKUP weird #N/A

[nacho25]

Function breaks when searching for values 1, 2 y 3 in this table, the output is #N/D. No even selecting the cell itself has to find makes it works.

Please help.

https://prnt.sc/rdujqSWzNCnS

https://prnt.sc/79Dad5X8PN2K 

[#2]

@nacho25 

Try =BUSCARH(L21:F21:T29;4;FALSO)

[#3]

@nacho25 have you seen the answer to your crossposted question at https://www.excelforum.com/excel-general/1390190-hlookup-doesnt-work-for-this-table.html#post5734594