Hi guys, me again.
I have one code like this, its in spanish
=BUSCARV(L395;'[FACTURAS POR PAGAR (CEMENTO).xlsx]FACTURAS CEMENTO'!D:H;1;FALSO)
I select the word of the cell L395 to vlookup in other book, example I look for the value 1500 but in the other book say a1500, I need put * in the formula like =VLOOKUP("*"&L395....
But when I find the value like only 1500 with the same formula this formula =VLOOKUP("*"&L395.... it doesn't work for me cause the formula search the value after other value, cause have "*", how can I make the formula for look the value 1500 for example, before, after or between other value?? I want to have in differents cell a1500, 1500, 1500a, a1500a and find 1500 with VLOOKUP, I have this code for this actually but this slows down my excel because have one "*" like condition for one VLOOKUP
=SI.ERROR(SI(L404=0;"SIN INFO";SI.ERROR(BUSCARV(L404;'[FACTURAS POR PAGAR (CEMENTO).xlsx]FACTURAS CEMENTO'!D:H;5;FALSO);SI.ERROR(BUSCARV("*"&L404;'[FACTURAS POR PAGAR (CEMENTO).xlsx]FACTURAS CEMENTO'!D:H;5;FALSO);SI.ERROR(BUSCARV(L404&"*";'[FACTURAS POR PAGAR (CEMENTO).xlsx]FACTURAS CEMENTO'!D:H;5;FALSO);BUSCARV("*"&L404&"*";'[FACTURAS POR PAGAR (CEMENTO).xlsx]FACTURAS CEMENTO'!D:H;5;FALSO)))));"")