=HLOOKUP weird #N/A

Occasional Visitor

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 Replies

@nacho25 

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