I'm trying to use the following formula to find a value of SIPK0SIA1 on the cell range bellow but it comes up with #NA!. Any ideas on how to fix this?
=VLOOKUP("*"&A1&"*",B1:G3,3,FALSE)
The format for all cells is text and if i search for any of the other field values by placing it in A1 it works. Thanks for your help in advanced.
=VLOOKUP("*"&A1&"*",B1:G3,3,FALSE)
The format for all cells is text and if i search for any of the other field values by placing it in A1 it works. Thanks for your help in advanced.
# | A | B | C | D | E | F | G |
1 | SIPK0SIA1 | 3327710 | 8421.99.90 | LOS DEMÁS | 1 | Unidades | cartucho para desionizador. Y .SIPK0SIA1 SimpliPak 1, Qty Pk 1 SIPK0SIA1 |
2 | =VLOOKUP("*"&A1&"*",B1:G3,3,FALSE) | 3327711 | 8421.99.90 | LOS DEMÁS | 1 | Unidades | cartucho para desionizador. Y .SIMFILTER Simplicity Final Filter, Qty Pk 1 SIMFILTER |
3 | 3327712 | 8421.99.90 | LOS DEMÁS | 1 | Unidades | Filtro para desionizador. Y .3501012210 Filtros UF, 10,000 lts para desionizador Ultra 373 3501012210 |