Forum Discussion

nacho25's avatar
nacho25
Copper Contributor
Sep 30, 2022

=HLOOKUP weird #N/A

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

  • Kaper_'s avatar
    Kaper_
    Copper Contributor

    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 

Resources